Help with Question on formula - getting unparsable - eyes are crossed

Hi, I took my formula which worked in excel and have tried to reproduce it in smartsheet and I am getting an unparsable, I am going cross-eyed trying to figure out what I am doing wrong. Here is the formula if someone can help me figure it out. thank you - Amy

=IF(AND(ISTEXT(ExpirationDate1), Datefirst1 = "", Datesecond1 = ""), "N/A", IF(Datesecond1 <> "", Datesecond1 + 14), IF(Datefirst1 <> "", Datefirst1 + 14, DATE(YEAR(ExpirationDate1), MONTH(ExpirationDate1) - 1, DAY(ExpirationDate1)))))

Find more posts tagged with

Accepted answers

All comments

Sam_Harwart

@amy pelayo

A couple of suggestions: first, I think there is an extra parenthesis (see below); second, I'd make sure there are no invalid dates in any of your columns.

=IF(

AND(ISTEXT(ExpirationDate1), Datefirst1 = "", Datesecond1 = ""),

"N/A",

IF(

Datesecond1 <> "",

Datesecond1 + 14), <---------- Remove this parenthesis

IF(

Datefirst1 <> "",

Datefirst1 + 14,

DATE(YEAR(ExpirationDate1), MONTH(ExpirationDate1) - 1, DAY(ExpirationDate1)))))

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.