How can I flag a parent task if 1 or more children tasks are flagged at risk?

Hello,

I'm looking to create a formula that will flag a parent row if 1 or more children tasks are at risk.

My current formula supports all my necessary conditions, but I can't figure out how to flag parents rows.

=IF(ISBLANK([Ideal Completion Date]@row), 0, IF(Status@row = "Completed", 0, IF([Ideal Completion Date]@row <= TODAY(-1), 1)))

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi,


    If you are planning to tag the parent at Risk even if you have one of the child rows at risk, you can write a formula in all Parent rows as =IF(COUNTIF(CHILDREN(Risk column), 1)>0, 1, 0). If you want parent rows to dynamically have this formula and not the standard formula, you will need to have a helper column to define the hierarchy and use that in the formula to combine both formulas.

    Thanks,

    Aravind

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!