IF Formula with Children

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.

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try something like this:

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

    thinkspi.com

Help Article Resources