Forumla help sought so cancelled tasks are not counted as at risk

Options
Phil Wightman
Phil Wightman ✭✭✭✭✭✭

This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete.

=IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0))

Question - What needs to be changed so that it does not surface tasks with the status 'cancelled' as these are not at risk.

Answers