How to Auto-populate dates from Project Deadline

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!