Formula for Parent/Child based on how it is answered

Rave007

Hello, I am trying to use a formula that can be used for data validation. So if a grandchild is selected as "In Review" but the other grandchild rows are still in "Not Reviewed" I want the child and parent to reflect that overall section as "In Review"

How would I set this up? I know I can use the =SUM(CHILDREN()) for counting the children to total the number to the parent but Im stuck on the logic for words.

review.PNG

Rave007

AravindGP

Hi @Rave007

Are these the only two possible options in this column? If yes, you can write this formula in all your parent rows. =IF(CONTAINS("In Review", CHILDREN()), "In Review", "Not Reviewed")

Rave007

There are 3 options

In Review

Not Reviewed

Review Completed

Will this formula change to In Review if there is 1 or more items under the parent "in review" even if others show "Not Reviewed" and "Review Completed"? My hope is once all are marked completed, it will change the parent to "Review Completed". Hope this makes sense.