Parent RAG light Formula
I cannot get the syntax correct.
I am looking for a formula where the parent row will show a green RAG light, if all of the children RAG lights are green, if any of the children RAG lights are red, then red, otherwise yellow.
The children rag lights have their own formula driven off a date which works great. I just do not want the parent RAG light to be date driven but children rag light driven.
Thank you!
Answers
-
Try something like this:
=IF(COUNTIFS(CHILDREN(), @cell = "Red")> 0, "Red", IF(COUNTIFS(CHILDREN(), @cell = "Yellow")> 0, "Yellow", "Green"))
-
Its coming back with an unparaseable error. Am I editing the formula at all? Or copying and pasting as is?
-
It SHOULD be a straight copy/paste. Can you post a screenshot of the formula actually in the sheet similar to the screenshot below?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 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!