Change "end date" based on status changes

Amber Eakin

When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies and baseline reporting, I need the End Date to accurately reflect completion. I appreciate your consideration of this idea!

Ksephora

Great idea! I love this because my users don't want to have to make two changes if one could automate the other.

Haissam

UPVOTE!!

I would love to see this possibility happening in the Smartsheet. I also need to monitor the Planned (Baseline) vs Actual completion date as on the Task Completion date. Let see how long it would take to be realized.

James Coventry

I would love this! Having to manually change the duration on the end date for all the different sheets takes up a lot of my time.