Automate Health
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?
Comments
-
What do you mean by "average"? Do you mean the majority of colors determine the parent or are you looking more for a "scoring" type of thing where each color is given a number, those numbers are averaged together, and then that determines the Parent Row color?
-
My algorithm to achieve this - for columns, not child rows - lookslike this:
=IF(COUNTIF(Schedule1:Quality1, "Gray") + COUNTIF(Schedule1:Quality1, "Green") = 4, "Green", IF(COUNTIF(Schedule1:Quality1, "Red") > 0, "Red", "Yellow"))
You would probably have to do some nested IF and COUNTF formulas to achieve something similar for child rows, maybe even combined with some fractions like COUNTIF/COUNT to trigger the correct result from the IF statements.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!