Skip to main content

Use formula field for Last modify time

  • January 3, 2021
  • 3 replies
  • 54 views
P
Forum|alt.badge.img+10

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

Kamille_Parks11
Forum|alt.badge.img+27

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

P
Forum|alt.badge.img+10
  • Pjero_Kusijanov
  • Author
  • Known Participant
  • January 5, 2021

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

Kamille_Parks11
Forum|alt.badge.img+27

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}.

Terms & ConditionsAccessibility statement