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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!