+ Start a Discussion
Ken sfdc1Ken sfdc1 

I need a proper formula for workflow rule

The criteria is :

Whenever Refills remaining field changed and if refill remaining is 1 or 0 i want a task alert for that rearrange this formula:

AND(ISCHANGE( Refills_Remaining__c ),((Refills_Remaining__c = 1)) OR
(Refills_Remaining__c = 0))))
Best Answer chosen by Ken sfdc1
Vishal_GuptaVishal_Gupta
Hi Ken,

Please try with below formula :

AND(
    ISCHANGE(Refills_Remaining__c ),
    OR(
        (Refills_Remaining__c = 1),
        (Refills_Remaining__c = 0)
       )
    )

Let me know if it will work for you.

Thanks,
Vishal

All Answers

Vishal_GuptaVishal_Gupta
Hi Ken,

Please try with below formula :

AND(
    ISCHANGE(Refills_Remaining__c ),
    OR(
        (Refills_Remaining__c = 1),
        (Refills_Remaining__c = 0)
       )
    )

Let me know if it will work for you.

Thanks,
Vishal
This was selected as the best answer
Ken sfdc1Ken sfdc1
Error: Function ISCHANGED may not be used in this type of formula
Vishal_GuptaVishal_Gupta
Hi Ken,

Please choose the below evaluation criteria in your workflow and then give a try again.
User-added image

Please let me know if it will work for you.

Thanks,
Vishal