Help

Calculating scheduled delivery date based on creation date

Topic Labels: Dates & Timezones
423 0
cancel
Showing results for 
Search instead for 
Did you mean: 
mastervader
4 - Data Explorer
4 - Data Explorer

Hello! 

I have to calcualte a scheduled delivery date field that adds time to the order date based on a combination of the number of pages and whether there is expedited processing or not. 

Screenshot at Mar 23 11-10-59.png

 

I was able to get the formula to sort of work using IF and DATEADD but the thing is that these are based on ranges and the formula is getting very long since it needs to determine a page range and then verify if it's expedited or not. 

Screenshot at Mar 23 11-12-54.png

 

 

Does anyone have any tips on how to solve this? Ideally automations would work but I can't add a formula there. 

0 Replies 0