IF AND combined.


I am having trouble getting the below to work. UNPARSEABLE

Separate as two IF's they work but I want it combined, so if a task is not marked in status as "Complete" and the date is earlier than today by 3 days the cell to display"urgent"

=IF(AND(Status9) <> "Complete"; ([End Date]9)= TODAY(-3)"URGENT")

Appreciate your help.

Thanks Chris

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!