use single select field values in input select

[James_Rhoads]

Hello!

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!

[TheTimeSavingCo]

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

[James_Rhoads]

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.

[TheTimeSavingCo · Accepted solution]

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

Working version here

[James_Rhoads]

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

Thank you!