Date a field status is changed

Topic Labels: Formulas
816 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am looking to create a formula that enters a date when the status of another field is changed


a field called “Job State” is changed to “sent to writer” and then the formula would fill in the date that action was made

I am then going to build a Zapier Zap to kick out a status update email to the client

1 Reply 1

You can use the “Last modified time” field type to capture the time a field is changed. However, if you change the “Job State” field again, then this field will change again. There’s no way to set it up to hold the date of a change to just a particular status option:

CleanShot 2020-03-25 at 14.38.44

But you could potentially combine this with a Script block that works on a view filtered to show only records where “Job State” == “sent to writer” – the Script block could grab the value of the “Last modified time” field (which would be the time that the “Job State” field was changed to be “sent to writer”, ergo the View filter), and write it to a Date field called “Date Sent to Writer”.