Skip to main content

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 respuestas
  1. 2 mar 2023, 1:37

    Hi @Alexis Tatham ,

     

    Try this

     

    AND(

    ISPICKVAL(Type__c , "Repair/Maintenance"),

    ISBLANK( TEXT(Priority) )

    )