+ Start a Discussion
Amanda ShowersAmanda Showers 

Validation Rules for picklist and text fields

User-added image

I need the "Former Customer Notes" field (which is a text field) to become required when the "Former Customer" field (picklist)  is marked "Yes." What is the formula to do this?
Best Answer chosen by Amanda Showers
AgiAgi
Hi,

AND(
ISPICKVAL(Former_Customer__c, "Yes"),
ISBLANK(Former_Customer_Notes__c ))

All Answers

Pavan Kumar KajaPavan Kumar Kaja
Try Below one.

(ISBLANK(Former Customer Notes), NOT(ISBLANK(TEXT(Former Customer))))


AgiAgi
Hi,

AND(
ISPICKVAL(Former_Customer__c, "Yes"),
ISBLANK(Former_Customer_Notes__c ))
This was selected as the best answer