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

Abdel Atia
edited 12/09/19 in Archived 2017 Posts

Hello everybody

 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



This discussion has been closed.