Using automations to timestamp based on single select


I am trying to create timestamps of the start can completion date based off of a status field I have set up. I have a status field, a Start Date field, and a Completed field. The status has the single selections of “To Do”, “In Progress”, and “Completed”. I have set it up, so timestamps are automatically populated into the Start Date and Completed fields based off of “In Progress” and “Completed” status. I wanted to know if there was a way to clear the records within the Start Date and Completed fields when the “To Do” status is selected? Is this possible?

Thank you in advance for the help!

Hmm, this would be possible via an automation that triggered when the status of a record was “To Do”, and then the action would be to update the “Start Date” and “Completed” fields to be blank?

I feel like I’m missing something though, apologies

Yeah, I have set up an automation to detect the “To Do” status and I tried making a static date that wasn’t filled in, but that didn’t update the record unfortunately.

Hm, I just left the field empty and it seemed to work

Screenshot 2022-05-12 at 10.29.30 AM

Working version here

That worked! I just had to reselect the To Do Status.

Thank you!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.