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
Renee KroonRenee Kroon 

logic for workflow

Hi,
I want to create an Email Alert and cannot get the workflow logic right.
I now have this:
AND (ISCHANGED(AVTRRT__Bill_Rate__c),(Source_Candidate__c  = 'Qualogy'))
But I get the following message:
Error: Function ISCHANGED may not be used in this type of formula

Hope you can help to get it right.
 
VinayVinay (Salesforce Developers) 
Hi Renne,

Usually this error happens when the workflow evaluation criteria is not “when a record is: created, and every time it’s edited.

ISCHANGED  function is available only below:
1. Assignment rules
2. Validation rules
3. Field updates
4. Workflow rules if the evaluation criteria is set to Evaluate the rule when a record is: created, and every time it’s edited .
5. Formula criteria for executing actions in Process Builder.
6. This function returns FALSE when evaluating any field on a newly created record.
7. If a text field was previously blank, this function returns TRUE when it contains any value.
8. For number, percent, or currency fields, this function returns TRUE when:
a. The field was blank and now contains any value
b. The field was zero and now is blank
c. The field was zero and now contains any other value

Please mark as Best Answer if above information was helpful.

Thanks,
APAP
Hi,

might help- https://www.youtube.com/watch?v=paFR6O_mbNk