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.
Help Article Resources
Check out the Formula Handbook template!