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
Phillip MoseleyPhillip Moseley 

Workflow Email Alert Formula for (If Account Type equals Customer and Account Owner Changes

I'm trying to create a formula that will send email alert when Account Type equals Customer and the Account Owner Changes. Here is what I have tried which is not working so any help would be appreciated.

IF(ISPICKVAL(Type, "Customer") AND( ISCHANGED(OwnerId)
Balaji Chowdary GarapatiBalaji Chowdary Garapati
It would be some thing like this:

ISPICKVAL(Type, "Customer") &&  ISCHANGED(OwnerId)


Since the workflow rule condition area its self acts as an If condition, If clause doesnt need to be specified, and syntax for And will be

either

And(
Condition,
Condition,
.....).

or:

condtion && condtion && ...


Hope this helps:

Thanks,
balaji


 
king kullaiking kullai
hai,try this

                       if(AND(ISPICKVAL(Type, "Customer") ,ISCHANGED(OwnerId)),true,False)


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
kullayappa