Status Column updating for Parent

Emily McNeeley

I have a column "Current Status" that is filled in for each child row. I would like to automate the parent row showing in the following order

If "In Progress" appears for any child, then show "In Progress" for the parent

If "On Deck" appears for any child, then show "On Deck" for the parent

If "Manage" appears (but no on deck or in progress) then show "Manage"

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(), "On Deck") > 0, "On Deck", "Manage"))

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(), "On Deck") > 0, "On Deck", "Manage"))

Emily McNeeley

Perfect, thanks Paul - I was so close with what I had tried!

Paul Newcome

Happy to help. 👍️