You can. Wrap the LAST_MODIFIED_TIME() function inside an IF() function. Or does that not accomplish what you want? If not, could you describe your desired use case in greater detail?
You can. Wrap the LAST_MODIFIED_TIME() function inside an IF() function. Or does that not accomplish what you want? If not, could you describe your desired use case in greater detail?
Great, I appreciate. I didn’t know about the LAST_MODIFIED_TIME function. That should resolve what I need without an extra field.
Just for record, here are the situations where I am going to need it:
Example 1:
Field A - single select field
Field B - I want to show Last Modified Time when the specific single select choice was selected in the field. (I guess if the subsequently the single select field is changed, then the Last Modified Time field would become blank)
Example 2:
Field A - Lookup field
Field B - Same as above, the last modified time would only show the time when the lookup value was a specific value in the Field A.
If field A (Edit: correction) contains any other than a value matching the condition in Last Modified Time, then the Last Modified Time will be blank.
So yes, the LAST_MODIFIED_TIME formula should work fine.
If anyone ever comes here looking for what I came here for (Zapier integration relying on Last Modified Time)...make a custom View that filters by your condition of interest and then use that View in your Zapier. Doesn't trigger when a record is removed from the view. Does trigger when a record is added (or added back after being removed earlier).
