Set an Expiry Date based on a drop-down selection

Hello All,

Wondering if somebody can help me out with this formula below:

I need to set an "Expiry Date" based on the selection of a dropdown menu which is logic carried over from a form (simple "YES" or "NO"). See below:

=IF(Fab logic@row = "NO", Created@row + 15, IF(Fab logic@row = "YES", Created@row + 30))

I've tried multiple revisions to the syntax but nothing seems to generate a proper date.

I've also tried using a helper column, where by if the Sales Rep does not select a Fabricator in the form (the "NO" answer), automation sets helper column to "15 Days". Then, I tried using that column and pointing to it with drop-down selection, but did not get anywhere either.

Can somebody help me figure out where I'm going wrong here? Would prefer simple method which I mentioned initially with "YES" or "NO" logic.

Thank you in advance!

Find more posts tagged with

Accepted answers

All comments

Courtney S.

Hi! You may want to review the IF function page - IF Function | Smartsheet Learning Center

Try breaking your IF function into the 3 parts to write them out logically and then combine them into the actual IF function with commas between them.

If Fab logic answer is NO: [Fab logic]@row = "NO"

Then add 15 days to Created date: Created@row + 15

Else/otherwise add 30 days to Created date: Created@row + 30

All together: =IF([Fab logic]@row = "NO", Created@row + 15, Created@row + 30)

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.