Set an Expiry Date based on a drop-down selection

torIT

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!

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)