Help

Use formula field for Last modify time

Topic Labels: Formulas
1444 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Pjero_Kusijanov
7 - App Architect
7 - App Architect

Hi everyone, happy new year :hugs:

I have a question regarding using LAST_MODIFIED_TIME() in a formula.
Is there a way to use LAST_MODIFIED_TIME() on another formula field type? I have formula field “Stage”, and I want to write a formula that recognise that there is a change in “Stage”.

Can you please help me achieve this?

Thank you,
Pjero

3 Replies 3

I believe all you do is add {Stage} to in-between the parentheses to give you the last modified time of only that field.

Pjero_Kusijanov
7 - App Architect
7 - App Architect

I get a message that the {Stage} field can not be used in LAST_MODIFIED_TIME();

“Sorry, there was a problem saving this field. Computed fields are not allowed since they can’t be directly modified.”

Is there other way around?

Thank you

Try using whatever fields {Stage} references to calculate itself within LAST_MODIFIED_TIME() instead. So if {Stage} references some other field called {Type}, base the new formula on changes to {Type}.