Hello! I am trying to make it so an exclamation point appears if something is past due and not complete. Here is my current formula:
=IF(AND(NOT(Status7 = "Complete"), TODAY() > [End Date]7), "High")
This is working great but it will have an exclamation point appear if something is past due and canceled. I would like for it to be blank if canceled as they won't complete that task.
Thank you for your help!