When cell from a row is marked as completed I want a second cell in same row to fill todays date

pbaer22

Hey all,

I'm trying to find a way to automate some metric tracking system. I've got a sheet that one of the rows has status updates and another that has completed date. When a cell is marked status for completed I want the completed date to automatically populate with the date that status is changed. Is there a formula to let this happen? I also dont want the date to change the next day, when I open the sheet up.

Thank you.

Darren Mullen

@pbaer22 Sure, use an automation workflow triggered by the status change and choose the action "record a date".

Darren Mullen

@pbaer22 Sure, use an automation workflow triggered by the status change and choose the action "record a date".

pbaer22

That's prefect, thank you very much!