In a custom list, I have a choice-type column named "STATUS" which has the following available choices:
- To command
I also created a Calculated column named "CHANGE" with the following formula:
= IF( OR( [STATUS]="To command", [STATUS]="commanded", [STATUS]="received"), Modified)
When I select an option of the choice column "STATUS", the "CHANGE" column is updated with the current date. It works as I expect.
My problem is that the Calculated "CHANGE" column also updates when some other field on the item is updated, even when "STATUS" remains unchanged.
How to update the Calculated date only if column STATUS is modified?