Nested IF Statement to Produce a Date?

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!

Smartsheet Test.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!