Needing Help with Multiple Logical Expressions Formula

Jed Rusyniak
Jed Rusyniak ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am working on a formula that will look at a few different cells and make a calculation.  I need the formula to look at 

ETA to Ready = [terminal ETA] + [# of days]

The [# of days] is determined by which [Terminal]  So I need the formula to look at the value in the [Terminal] column, then add the associated [# of days] to the [Terminal ETA] date for the actual [ETA to Ready]

 

For example, if the Terminal ETA date is 4/10/19 and the Terminal is "APM" which is associated with a "3 day" I would want the formula to return a value of 4/13/19.  Not sure if I'm making sense with this formula, but would love some assistance. 

 

Screen Shot 2019-04-18 at 6.09.12 AM.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!