IF, And, Not

Joely Kremer
edited 12/09/19 in Smartsheet Basics

Please, I need help with a formula.

If the status is NOT Complete and the Due Date is IN THE PAST, "Missed". Otherwise it should indicate "On Track".

Criteria:

Status: NOT "Complete", AND Defined Due Date: "In the past", "Missed"

Status: NOT "Complete", AND Defined Due Date: "In the future", "On Track"

 

 

Comments