Red Flag for overdue tasks


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.


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?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!