Can we use formula field in ISCHANGED() formulas in Workflow rule criteria

[Ketan P Solanki]

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

[@anilbathula@]

Hi 

Check this link about ischanged() function in detail :-

http://ap1.salesforce.com/help/doc/en/customize_functions_i_z.htm#ISCHANGED

[Ankit_Arora · Accepted solution]

To make it easy :

This function is available only in:

• Assignment rules
• Validation rules
• Field updates
• Workflow rules if the evaluation criteria is set to Evaluate the rule when a record is: created, and every time it’s edited.

Thanks

Ankit Arora

Blog | Facebook | Blog Page

[Ketan P Solanki]

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 Sevugappe…]

 Hi I think you have not selected the radio option  Created and every time its edited.  I have added the formula and validated with no erros.

Guna