Deadline based on Priority dropdown menu

203jk ✭✭
edited 12/09/19 in Formulas and Functions

Hello all,

I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline column to calculate a date based on the priority picked. ie- if someone picks urgent, the deadline would calculate a date 3 days after the date the form was filled out, if they picked semi-urgent then it would calculated a week later. if they picked can wait it would put no date.... Is this possible? 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!