You need to sign in to do that
Don't have an account?
Ketan Solanki29
Can we use formula field in ISCHANGED() formulas in Workflow rule criteria
Hello i want to use formula field in ISCHANGED() in Workflow rule criteria but i get error like bellow.
Formula :
IF( AND ( Risk_Rating__c = 'D' , Total_AR__c > 0 , ISCHANGED( Oldest_Due_Date__c ) , true, false) )
Note : here Oldest_Due_Date__c is formula field with Date return type.
Error: Function ISCHANGED may not be used in this type of formula
To make it easy :
This function is available only in:
Thanks
Ankit Arora
Blog | Facebook | Blog Page
All Answers
Hi
Check this link about ischanged() function in detail :-
http://ap1.salesforce.com/help/doc/en/customize_functions_i_z.htm#ISCHANGED
To make it easy :
This function is available only in:
Thanks
Ankit Arora
Blog | Facebook | Blog Page
Yes i use the Evaluation Criteria
created, and any time it’s edited to subsequently meet criteria
i got the problem due to this Evaluation Criteria the above error is occur. this criteria not support ISCHANGED and PRIORVAL function.
Thanks
Guna
The following statement:
AND ( Risk_Rating__c = 'D' , Total_AR__c > 0 , ISCHANGED( Oldest_Due_Date__c )
would return the correct TRUE or FALSE values as as is.