Problem with returning a result when between 31 and 90 days...

I have a sheet that I am trying to return a 1 if the due date is within the next 30 days, a 2 if the due date is between 31 and 90 days, and a 3 if the due date is over 90 days. The formula below returns the 1 correctly but gives me an #Incorrect Argument error for the others. Can anyone let me know what I am doing wrong? Thanks so much in advance!

=IF([Due Date]@row <= TODAY(+30), 1, IF(AND([Due Date]@row <= TODAY(+31), [Due Date]@row <= TODAY(+90), 2, 3)))

Find more posts tagged with

Accepted answers

All comments

Frank S.

Greetings @SASardy,

Please give this formula a try:

=IF(Date@row <= TODAY(30), 1, IF(AND(Date@row >= TODAY(31), Date@row <= TODAY(90)), 2, 3))

Let me know if you need additional help.

SASardy

@Frank S. I tried your formula and Smartsheet said the formula syntax isn't quite right.

Never mind, I figured it out. Thank you so much!

Frank S.

@SASardy,

My apologies; I should have clarified that you would need to change the Date@row to whatever column name you wanted to check the date.

I'm glad it worked out for you, and I hope I got you on the right path.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.