How to Auto-populate dates from Project Deadline
Options
Hi there,
I am setting up timeline "project" templates for my team. We have a handful of projects each year and they all will follow this same process so the duration for tasks and logic "predecessors" are already built in. I want to be able to set a deadline in the Baseline Start/Finish column on the project complete row and then have the dates auto populate in that same BS/BF column all the way to the start of the project. This should be able to quickly show if a deadline is realistic and what is the latest possible date we can start certain tasks. How can I set up a dates that auto-populate based on a deadline date?
Thank you
Answers
-
You would structure your predecessors column to work backwards.
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!