Help

Using automations to timestamp based on single select

Topic Labels: Automations
Solved
Jump to Solution
1199 4
cancel
Showing results for 
Search instead for 
Did you mean: 
James_Rhoads
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2022-05-12 at 10.29.30 AM

Working version here

See Solution in Thread

4 Replies 4

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.

TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2022-05-12 at 10.29.30 AM

Working version here

James_Rhoads
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Thank you!