Help with Formular with two criteria adding to date value

Hello,

I am assisting a team in moving from an excel sheet to Smartsheet. The formula they currently use to perform a calculated function isn't working and I am getting INVALID DATA TYPE as the error. I admit I am not the best formula writer.

Basically if the new row meets he two criteria only then should the cell populate by adding 60 days to the Date Received value.

=IF([Review Type]@row = "Employee Requested", (AND([Current REPR]@row = "OAH", [Date Received]@row + 60, 0))

Thank you for your help!

Find more posts tagged with

Formulas

Accepted answers

All comments

Kelly Moore

Hey @Nancy K

I think this is what you're asking for

=IF(AND([Review Type]@row = "Employee Requested", [Current REPR]@row = "OAH"), [Date Received]@row + 60, 0)

Did you mean that if the criteria was not met for the value to be zero? Or did you mean that zero would be added to the [Date Received] value if the criteria was not met? As written the False value returns a zero.

Kelly

Nancy K

@Kelly Moore Thank you! I am hoping it will add 60 days to Date Received if met or leave blank if not.

I just remembered " " is actually blank so I fixed it but I can't seem to get the +60 to work. It is giving me INVALID COLUMN VALUE as the error.

Kelly Moore

Hey

The column type for [Date Received] is a date column, correct? If yes, how is the [Date Received] entered into the sheet?

Kelly

Nancy K

Yes it is a date column. 2 digit month/day/year

Kelly Moore

The column that houses this formula is also a Date column, correct?

Nancy K

@Kelly Moore Thank you so much!!! I swear sometimes its the little things!

Kelly Moore

Lol, yes, you are so right. I'm glad it was something easy to fix.

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.