+ Start a Discussion
Ketan Solanki29Ketan 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

Best Answer chosen by Admin (Salesforce Developers) 
Ankit AroraAnkit Arora

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

All Answers

@anilbathula@@anilbathula@

Hi 

 

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

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

Ankit AroraAnkit Arora

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

This was selected as the best answer
Ketan Solanki29Ketan Solanki29

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 SevugapperumalGuna Sevugapperumal
 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

 

 

 

 

 
Guy BickelGuy Bickel
I know this is an older post - but just in case some ran across it I thought I'd add that the outer IF statement isn't required here.  

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. 
sandeep reddy 37sandeep reddy 37
can we use ihis method in apex programing