Formulas

jconnolly

I'm trying to move an excel project timeline to the Gaant template.  I currently calculate my dates backwards from the desired in stock date.  I've put in my duration for each step, but wanted to know how i can set aformula to deduct the duration days from the in stock date, rather than inputting a start and end date manually?

Paul Newcome

Can you provide a screenshot or some column names? From the sound of it, you should be able to use:

 

=[Stock Date Column Name]@row - {Duration Column Name]@row

J. Craig Williams

What you want a reverse or work-back schedule.

See this post for more:

https://www.smartsheet.com/blog/support-tip-work-back-schedule?_ga=2.92243290.1944526638.1531309748-1970619559.1527950072

Craig