#Unparseable If Statement

Tristan D

Hello,

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.

T

Colleen Patterson

@Tristan D

i would believe that your issue is not having brackets around [Due Date]

Column names that a) have a space b) have a special character or c) have a number at the end need to be wrapped in brackets when referencing.

Tristan D

@Colleen Patterson Thank you for your help, this is good to know. A bit of a change from Excel so still learning.

I added the brackets around due date but now faced with a new error #Invalid Operation. Any ideas? Thank you again

Colleen Patterson

@Tristan D

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

There should be no space between the carrots in the status portion.

Tristan D

@Colleen Patterson THANK YOU, this worked!!

Colleen Patterson

@Tristan D Happy to help!