"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!

[KitzyKitt]

Sounded straight forward until I tried to set it up:

Using your example: I want to update [Column B] if [Column A] changes.
To do this, we update [Column C] if [Column A] changes.  
I still have the same problem.  How do I know if [Column A] changed?

[yasarcan]

Biçim kuralları ile renk atayın

[Gustavo_Eduardo]

Super tip!!!