#Unparseable If Statement

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.

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.