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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!