Formula for Date based off Dropdown

I am looking for help with a formula to calculate a due date based off a drop down. I have 3 options in the dropdown and need to calculate a date based the requested date. <10,000 = quote due in 5 days from requested date . <50,000 quote due in 14 days from requested date <100,000 quote due in 30 days from requested date.

image.png


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!