+ Start a Discussion
jisaacjisaac 

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:

AND
(
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?
JakesterJakester
Is the TCV a sum of line items or other formula? If so, then changing the dependent data would obviously trigger this. 
jisaacjisaac
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.....
JakesterJakester
Hmmm... when you say it's totally unrelated, is it still a field on the opportunity product object?
jisaacjisaac
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.