Parent RAG light Formula

toni.forrest

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!

Paul Newcome

Try something like this:

=IF(COUNTIFS(CHILDREN(), @cell = "Red")> 0, "Red", IF(COUNTIFS(CHILDREN(), @cell = "Yellow")> 0, "Yellow", "Green"))

toni.forrest

Its coming back with an unparaseable error. Am I editing the formula at all? Or copying and pasting as is?

Paul Newcome

It SHOULD be a straight copy/paste. Can you post a screenshot of the formula actually in the sheet similar to the screenshot below?