Automating Start Dates and End Dates within a Project Plan

Hello there!

How do I automate or create formulas to predict start and end dates for a project plan / timeline in Grid view? We have four stages - Planning and 3 to 4 different Creative Asset delivery dates for 4 departments. Look forward to your guidance here!

Answers

  • Leroy Noriega
    Leroy Noriega Community Champion

    Make sure you have the start date and end date as date columns. Then select Gantt view, this action will add duration and predecessors. You can now customize the predecessors and the duration to your linking.

    image.png image.png

    Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant

    Core App, Project Management and System Administrator Certified🏅

    E: leroy.noriega@yahoo.com | Linkedin Profile

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!