Nested IF Statement to Produce a Date?

Tessa Heath

I am really struggling with complex Smartsheet formula's. I am trying to produce a start date for different action items based on the below logic (also attaching a screen shot for reference):

If "Isolated or Existing Market" = Isolated, then Start Date Test = (Grand Opening) - 10 days

If "Isolated or Existing Market" = Existing, then Start Date Test = (Grand Opening) - 5 days

"Isolated or Existing Market" is a drop down column, "Grand Opening," "Start Date Test" and "Start End Test" are all date columns.

Is this formula possible to create? Thanks for any help!

Andrée Starå

Hi Tessa,

Try this.

=IF([Isolated or Existing Market]@row = "Isolated"; [Grand Opening]@row - 10; [Grand Opening]@row - 5)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Tessa Heath

This worked perfectly, thank you so much! I did have to swap the semi-colon for a comma, then viola! I really appreciate you taking the time to help me out!

Andrée Starå

Great!

Happy to help!

Have a fantastic weekend!