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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!