Help

If value changes insert timestamp in another field when it was changed

Topic Labels: Formulas
1407 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Midnight_Mushro
4 - Data Explorer
4 - Data Explorer

I’m trying to insert a timestamp into a field when a value on a record changes. I’ve got this but it’s not really updating like I was expecting.

IF(Stage=“3. Fruiting”, NOW(),0)

It seems to be updating randomly. Any ideas?

2 Replies 2
AlliAlosa
10 - Mercury
10 - Mercury

NOW() will always show the current date and time.

You’ll want to use LAST_MODIFIED_TIME(), instead. Try this:

IF(Stage = "3. Fruiting", LAST_MODIFIED_TIME(Stage))

Hope this helps!

Midnight_Mushro
4 - Data Explorer
4 - Data Explorer

That seems to be working! Thanks!