End Date - Move End date on current task if task isn't complete

Hi I would like to have the fuctionality to see what the projected date of completion is going to be on my project based on the outstanding tasks. Currently when a end date is reached it doesn't move on so doesn't move the dependancies which means the overall project plan stays at the original baseline. The only way to move it on is by updating the End Dates for the tasks that are not complete.

Can you please advise if there is a way to acheive auto-moving a project on based on completion status?


Many thanks,

Mike

Answers

  • Michelle Choate 2
    Michelle Choate 2 Community Champion

    Hey @Michael Foster , do you already have a baseline on your project? Or do you use manual baselining? Also, you could use an automation to continue to move the dates forward based on a condition, which will then move the anything that is dependent on it forward and show you the variance from the baseline columns.

    If you want to walk through creating the automation, my calendar link is in my signature :) Happy to help on zoom!

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!