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

courtney.w

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)))

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.