I need help with a validation rule please. Basically on our General ledger object, there is a type field and a revaluation type field. Both of these fields are picklist. We want to set a validation rule such that when the type field is set to "balance sheet" and the user attempts to save a record the system prompts the user to select the "revaluation type"
Can someone please help
Thank you
1 resposta
Hi Temitayo, Please try:
AND(
ISPICKVAL(Type__c , 'Balance Sheet'),
ISBLANK(TEXT(REVALUATION_TYPE__C))
)
Update the API Names for the fields as per your setup