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

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)

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”

1 Like

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

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.