Skip to main content

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!

Reply


Terms & Conditions