Help

Show a specific update date as record field

Topic Labels: Formulas
Solved
Jump to Solution
1023 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevin_Rein_Alvi
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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:

Screen Shot 2020-12-26 at 10.10.29 PM

Screen Shot 2020-12-26 at 10.10.49 PM

Screen Shot 2020-12-26 at 10.10.59 PM

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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:

Screen Shot 2020-12-26 at 10.10.29 PM

Screen Shot 2020-12-26 at 10.10.49 PM

Screen Shot 2020-12-26 at 10.10.59 PM

Thank you, @ScottWorld, this makes perfect sense!