Formulas for visual symbols
Are there any formulas specific to visual symbols to simplify summary data for parent rows?
I have a RYGB status for activities within a project and would like to be able to summarise the 'worst' status in the parent rows. For example, if three activities are green (on target) and one is yellow (slight delay) then the whole section/project should be treated as yellow. If any activity is red, then the whole section/project should be treated as red. I then roll this overall project status into a summary sheet.
At the moment I am using a rather long-winded IF statement. Is there anything more simple I can do with parent functions and/or anything to do directly with the symbols
Thank you - I hope I have explained myself clearly enough, feel free to ask for additional info if not!
Answers
-
Without seeing your current formula, I can't provide any specific details, but the way I usually do this is:
=IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", "Green"))
or something along those lines.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!