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.
Automating Parent Row based off RYG Children Rows
I am looking for a formula that will show in the parent row an RYG color based on the children.
If there are any Red OR Yellow in the children rows, I want the parent row to show Yellow.
If there are only greens (no other color), I want the parent row to show Green.
How do I do the "or" statement? Thanks for any help!