function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

ISCHANGED formula not working properly - can someone see what is wrong?

I want an email alert to be triggered when the Stage is Closed Won and the field Total Contract Value (TCV) has changed.

Here is what I built:

ISPICKVAL( StageName , "13. Closed Won"),
IsChanged( Total_Contract_Value__c )

However, it is triggering an email when fields are changed that do not affect the Total Contract Value field are changed and I only want to be notified if the TCV has changed.

Any ideas?
Is the TCV a sum of line items or other formula? If so, then changing the dependent data would obviously trigger this. 
Yes, it is a calculated field.
But the email is being triggered even when I changed a date field totally unrelated to it.  So I am puzzled.....
Hmmm... when you say it's totally unrelated, is it still a field on the opportunity product object?
Yes, the one that has been triggering it lately is the field for Installed Date, which does not have anything to do with the Total Contract Value. We go in long after a deal has closed to add that once the software has been installed.