Show a specific update date as record field

[Kevin_Rein_Alvi]

My records are created from automation, representing tasks that were started. I have a created date field that represents the start date of the task. I also have a single-select field that staff use to mark a task completed, among other statuses. I want to be able to know when the status has been marked completed and show that date as a record field so I can then compare and check if tasks are completed the same day they were started, and if not, how long they took to complete. I’m not even sure this can be done or if there are other ways to get to what I want but I appreciate any advice! Thank you!

[ScottWorld · Accepted solution]

Welcome to the community, @Kevin_Rein_Alvia!

1. Create a field of type “Last Modified Time”. You can set it to update only when your “Status” field is updated.

2. Create an automation triggered by “When record matches condition”. Set it to trigger when your “Status” field changes to “Completed”.

3. For the action, have it “Update Record”, and have it update a new date/time field named “Date Completed” to the contents of your “Last Modified Time” field.

It would look like this:

[Kevin_Rein_Alvi]

Thank you, @ScottWorld, this makes perfect sense!