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!
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”
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.