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/


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"...

  • 3
    You can create a validation rule to check for 'Blank' picklist values by using: 'ISPICKVAL(Office_Type__c, '')' – Ricky Hewitt Dec 17 '13 at 23:56
  • Thanks @RickyHewitt, forgot about this simpler option completely :) – eyescream Dec 18 '13 at 16:52
  • Hi CGarcia! A follow-up after 1 month? :D If you have no more questions or issues with it - would you mind marking the answer as accepted so it goes "off the radar"? – eyescream Jan 17 '14 at 19:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.