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

[Brad_Lockhart]

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!

[Kamille_Parks]

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”

[Brad_Lockhart]

Kamille_Parks:

IF({Status}=“Delivered”, LAST_MODIFIED_TIME({Status}))

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