IF Formula with Children

Laura Consuegra

Hello Everyone,

I am trying to figure out a formula that would show the children's status on the parent row. IF the children's "Status" column is "Completed" OR "Completed By Black Ops", the parent "Case Status" column should be "Completed", otherwise, "Pending"

Thank you in advance.

Paul Newcome

Try something like this:

=IF(COUNTIFS(CHILDREN(), CONTAINS("Completed", @cell)) = COUNT(CHILDREN([Case Identification No.]@row)), "Completed", "Pending")