How do I amend this formula


What should this formula look like if I also want it to ignore any tasks that do not have an end date?

=IF(AND([End Date]8 < TODAY(), NOT(Status8 = "Complete")), 1, 0)

Its template formula from a project template set that surfaces at risk tasks to the roll up dashboard. IE those where the end date is i the past and the status is other than complete.

I was thinking that it needs another nested IF statement but unsure how to add.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!