Date formula to set cut off period

Adedeji Adebanjo
Adedeji Adebanjo ✭✭✭
edited 08/02/23 in Formulas and Functions

I am trying to set a date formula to for the following statement;

if the [Next Due Date] is <= 27/07/2023 return "Performed"


=IF(ISBLANK([Last inspection]@row), "", IF(DATE(2023,7,27)) < [Next Due Date]@row, "Overdue", "Performed"))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!