Milestone met, change end date

I have a task that a team member has a month to complete. Instead of the team member needing to update the Date Finished column, I would like them to be able to mark the milestone as complete and have the milestone start/finish update to [Today] which would trigger the end date of the Task above match the milestone date. I'm at a loss as to what linking and formulas I'd need to make this. I would need it to be applicable just to certain rows, not worksheet or even column wide.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!