If Billing Country (a text field) contains "Australia" or "New Zealand", picklist field "Account Business Unit" can't be blank.
Thank you.
2 risposte
Norm, just use this:
AND(
ISBLANK(Account_Business_Unit__c),
OR(
BillingCountry = 'Australia',
BillingCountry = 'New Zealand'
)
)
If account business unit is a picklist field,
AND(
ISBLANK(TEXT(Account_Business_Unit__c)),
OR(
BillingCountry = 'Australia',
BillingCountry = 'New Zealand'
)
)
That's it. Please insert the field names using the Insert Field button on the formula editor since I just assumed them.
