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
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
Check out the Formula Handbook template!