Red Flag for overdue tasks

Hi,

I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great.

BUT....

It now red flags every row that doesn't have a date in yes which is an issue as we are using a project management template which will house all backlog items etc that may not yet have dates allocated to them. Is there a way to stop this happening and only run the flag when there is a end date and % complete in the row but not when it is blank?


Thankyou!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!