Statement to read a text in one cell, then add a numeral (based on the text) to the date in another


Hi all, help please :)

I have 3 columns -

Approval Due Date

Requested Date


Step 1 - Approval Due Date to look at the Priority

Priority will be High, Moderate or Low / High = 7 days /Moderate = 14 days / Low = 21 days


Look at the Requested Date column and add the number of days relevant to the priority rating onto the Requested Date to get the Approval Due Date.

I have tried many things and failing lol. THANK YOU!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!