Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
mother cell status
I'm looking for a formula for a parent cell status with a set of children rows
The status of the mother cell should be green if all children are green.
It must be gray if all the children are gray
It must be yellow if at least one of the children is yellow or gray…
the formula must give the expected results as in the attached image
Thank you in advance for your help