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.