Skip to main content

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!

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


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



Working version here


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


Thank you!


Reply