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?
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?
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!
That seems to be working! Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.