IFS formula and adding number of days

Options

How to convert this Excel formula into Smartsheet

=IFS(ISBLANK(C3),"",E3="Product1",C3+30,E3="Product2",C3+15, E3="Product3",C3+30,E3="Product4",C3+30)

I would appreciate your help.

Thank you:)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!