Is it possible to count if a cell changes?

Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround?

In any given day the "current stage" column changes possibly many times. An example question would be:

how many times did a cells in "current stage" column change from "Art Production Lead Assigns Designer" to "designer create asset" today?

I know I can download the activity log everyday, but if there is a way I can automate this I would love some advice - I'm at a loss! Thank you in advance.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!