Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How can I get a timestamp based on a formula result (that doesn't keep automatically updating)?

Topic Labels: Formulas
Solved
Jump to Solution
418 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I’d like the date/time to be recorded based on the result of a formula but can’t seem to make this work. My formula basically compares two quantities (both numbers of course) and evaluates to “LOW” or “OK” depending the threshold I’ve set. I want another column to capture the date/time only if the formula results to LOW, but can’t seem to make this work.

Things I’ve tried.

  1. Had the second column evaluate to NOW() if the the previous column formula result is “LOW”. This doesn’t help because as long as the prev. column stays as “LOW”, the date/time column keeps updating the timestamp based on NOW(). I only want a static timestamp of when the formula evaluated that to low.

  2. I tried to use the LAST_MODIFIED_TIME(), but that cannot work on fields that are automatically calculated such as a formula field.

How would I accomplish this?

Thank you.

1 Solution

Accepted Solutions

I would just create an automation that inserts the value from your NOW() formula field into a date field whenever the record matches the condition of LOW.

See Solution in Thread

2 Replies 2

I would just create an automation that inserts the value from your NOW() formula field into a date field whenever the record matches the condition of LOW.

Thanks, Scott. Did just that.