Date duration subtraction
Not sure how to explain this. I have attached a photo of how its done in Excel and the actual smartsheet.
I have a migration state date of July 28th and several tasks after. I need the cell in start time to change if I decrease or increase the lead time. I cant figure out any formula or if its even possible.
Excel Example
Smartsheet
Answers
-
Hey @Zane Fielding,
It looks like you are trying to subtract a date from a number and return the resulting date. I have created an example below on how this formula may look like:
- Formula: =$[Migration Start Date]$1 - [Lead Time]@row
Take note that the "$" signs are used to create Absolute References.
I hope this helps!
Jaykel
-
@Jaykel Torres I am actually trying to subtract a number from a date and return the resulting date.
-
@Jaykel Torres I tried the above formula and got a #INVALID OPERATION
-
Were you able to find a resolution to your question or are you still working on this?