You need to sign in to do that
Don't have an account?
Phillip 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)
IF(ISPICKVAL(Type, "Customer") AND( ISCHANGED(OwnerId)
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
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