This is a tough one to explain so bear with me...
- I have two picklist fields, Type__c & Priority on the Work Order
The Need = to require Priority only if Type__c = Repair/Maintenance. BUT - optional for any other Type__c options.
So where I'm stuck.. is I can't use Validation rules since it's 2 picklist values.. and I can't use Field Dependencies because I need the field available at all times... but only required if Type__c = Repair/Maintenance.
I don't even know how to go about searching for this answer either since it's so... wordy. lol
Thanks in advance!
2 respostas
Hi @Alexis Tatham ,
Try this
AND(
ISPICKVAL(Type__c , "Repair/Maintenance"),
ISBLANK( TEXT(Priority) )
)