[SalesForce] Salesforce: Validation using two Picklist Fields

I'm trying to create a validation rule formula in Salesforce, that uses two picklist fields. If the first is picked as New Account, and the Second is Not Selected, then a validation rule appears: Office Type is required!

First Pick Value List: field name: OnBoarding Setup = New Account

Second Pick List Value: field name: Office Type = Blank or Not Selected or Null

Any help would be greatly appreicate it.

Regards, C/

Best Answer

Try this as the condition

ISPICKVAL(OnBoarding_Setup__c, 'New Account')) &&
(
    ISPICKVAL(Office_Type__c, 'Blank') ||
    ISPICKVAL(Office_Type__c, 'Not Selected') || 
    /* Add more values here if needed, join them with "||" ("logical OR") */
    ISPICKVAL(Office_Type__c, '')
)

Although I admit I'm not sure if your picklist really has the values like "Blank"...

Related Topic