Formula for Parent/Child based on how it is answered

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.


Tags:

Answers

  • AravindGP
    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")

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

  • 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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!