Automate Health

Cara Sikes

Cara Sikes ✭

05/28/20 in Formulas and Functions

I would like to have the parent row of my health column automatically be red, green or yellow based on the average health of it's child rows.

Does anyone have an idea of how to accomplish this?

0 ·

Comments

Paul Newcome ✭✭✭✭✭✭

05/29/20

I replied on your other thread about this.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

What do I need to enter for my 2nd criterion range in an index-collect formula?
Hi all, I'm looking for help with an index-collect formula. I want to collect the venue name from an existing sheet using the project name as my criterion. The problem I'm running into is I'm not sure what value to enter for the second criterion range. Below is the formula I currently have, which I know is incorrect. Any…
Grouping in reports does not show headers of the drop-down list
Hi I am a new user trying to test and see how much I can pull off from this amazing sheet. Well, I am trying to create a report with all the tasks for any given stakeholder. I am grouping the report based on the primary field that has values within a particular header as in the ss below: And, if you look at the report, it…
Countifs for a specific month
The AI-generated formula shows an invalid data type. I'm not sure what is wrong. What I want to do is count the number of items that are good for the month of December. =COUNTIFS([Fault Severity]:[Fault Severity], "good", MONTH([Last Update]:[Last Update]), 12)