Automation for Date Completed

[Jared_Wolf]

We want to auto-populate the current date and time in a column when updating the multiple choice field in a separate column. Everything looks correct in the automation but it is still not functioning correctly.

Real-use scenario: We have an Airtable for issue tracking. When the “Status” column is marked “Completed” we want the “Completion Date” column to auto-populate the current date and time.

We ran a simple three step automation for this and it is not functioning. Anyone have an existing process we can use?

[augmented]

Do you mind posting a screenshot of your automation?

[Jared_Wolf]

Hope this clarifies the issue a little more! Let me know if you need more info

[augmented]

Hi Jared. It looks like your update record action has only one field selected for update, “Requested Date”. Is that the right one because you mentioned “Completion Date” before?

If it is correct, you are not assigning a value to “Requested Date” as it sounds now. That’s why it’s not working. You need to add a Last Modified field to the Issues table (if you don’t already have it). Then, you assign the Last Modified field value from the record in the trigger to “Requested Date”.

Make sense?

[Jared_Wolf]

solved, thank you. It was the last modified addition that I needed.

[Justin_Barrett]

@Jared_Wolf Glad to know that you got the answer you were seeking! If you would, please mark the comment above from @augmented as the solution to your question. This helps others who may be searching with similar questions. Thanks!