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?