Red flag on/off control to indicate project RISK
I have a column named 'risk' and the flag only toggled on when certain conditions are met- uncompleted activities that exceeded 30 days after the planned end date;
=IF(Status@row = "Cancelled", 0, IF(AND([End Date]@row < TODAY(30), Status@row <> "Completed"), 1, 0))
It works pretty well but, I would like it not to toggled on rows that do not have start and end date (header rows)
Help Article Resources
Check out the Formula Handbook template!