"Reset on Edit" when anything in a specific column changes

[1minManager]

I’ve seen various posts but none really explained this simply and I thought it might be useful to some people. So how can you get Reset On Edit to run only when a specific specific column changes from anything, to anything?

[Column A] is the trigger column, we are looking for this to change
[Column B] is the column with the Initial Value we want to update automatically
Create [Column C] as a change timestamp, which only updates if [Column A] changes
In [Column B] set the Reset on Edit formula to be [Column C]=Now()

Hope this helps

Simon@1minManager.com

[WillowMobileSys]

Nifty tip! I don’t think I would have thought of this and I believe I might have some uses for this right away! Thanks for posting!!

[Daisy_Ramirez]

Thanks Simon, I just configured this scenario.

Just wanted to add, we’ll want to turn on the Reset on Edit flag on Column C too. It otherwise will not change the timestamp when changes are made

Again, a million thanks!