Re: How can I generate a formula based on the date a choice is made in a single select field?

611 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m looking to generate a formula that lists the date a record is moved to a specific selection from a single select field. Our company does video production and I want to track the actual dates projects are moved to a particular stage like “delivered” or “rough cut”. Currently, I have to go inside each record and look at the activity tracker. There must be a better way without creating another field. Thanks!

Screen Shot 2020-07-31 at 12.46.06 PM(2)

2 Replies 2

You could use a formula like this:

IF({Status}="Delivered", LAST_MODIFIED_TIME({Status}))
^ that will tell you date the field became set to “delivered”

Thanks! It was the emoji that was creating all the headaches.