Red flag on/off control to indicate project RISK


Hi All,

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)



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!