#Unparseable If Statement


I am relatively new to Smartsheet and was trying to write what I thought was a very simple line of code but keep getting a #Unparseable error and uncertain why. Below are 2 If statements that I have tried with the same results. I verified header names to ensure accuracy but same result each time.

=IF(AND(Due Date@row < TODAY(), Status@row < > "Complete"), "Overdue", "")

=IF(Due Date@row < TODAY() AND Status@row <> "Complete", "Overdue", "")

Appreciate any assistance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!