Hello all,
I'm still new to learning the syntax of writing validation rules. I'm trying to write a validation rule that requires an Annual Revenue to be populated AND an Industry to be selected for Accounts when the Type field identifies the account as a customer. Any help would be appreciated!
1 answer
Hello @Kyle Gianbruno
Could you try the formula mentioned below?
AND ( BEGINS(TEXT(Type), "Customer"),
OR ( ISPICKVAL(Industry, ""),
ISBLANK(AnnualRevenue)
)
)
or the below formula.
AND ( OR ( ISPICKVAL(Type, "Customer - Direct"),
ISPICKVAL(Type, "Customer - Channel")
),
OR ( ISPICKVAL(Industry, ""),
ISBLANK(AnnualRevenue)
)
)
