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 RYG And CHILDREN Formula
I am looking for a formula that will show in the parent an RYG colour based on the children.
If there are any Red in the children, I want to show Red in the parent,
If there are no Red but there are Yellow in the children, Show Yellow in the parent.
If there are no Red or Yellow but there is Green in the children, Show Green in the parent.
If there are no Red, Yellow or Green but there are Blue in the children, Show Blue in the parent.
I am completely stumped on what formula I need and if this is even possible.
Thanks in advance