How do I calculate dates from a cell whose value is based on a Formula?

I have a cell I would like to calculate a date that is based off another date minus the value of another cell that is calculated off a separate formula.

So I did =[Install Date]@row - [Projected Lead time]@row

The issue seems to be that [Projected Lead time]@row is a calculated =IF formula whose value is in number format. If I select any other cell [Number Format] that has a number format but doesn't have a formula, the formula =[Install Date]@row - [Number Format]@row works just fine.

Any thoughts?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!