Is there is a way to enforce [through Validation] that a value is chosen in a Multi-Select Picklist?
I am writing a validation to enforce that there is a value in a multi-select picklist prior to conversion. I already have a validation on the lead and was hoping to add a line that enforces that a multi-select picklist is not blank when converting. Here is the validation as it is written and it works well:
AND( IsConverted,OR (ISPICKVAL( Highest_Education_Level_Completed__c , ""),ISPICKVAL( Academic__c , ""),ISPICKVAL( Time_Available_for_School__c , "")))
However, what I need is to add a line that enforces that a MS Picklist is not blank - meaning the user must enter a value to proceed. Should I use the ISBLANK function? Is that even possible with MS Picklist?
5 respuestas
Michael, that is absolutely possible and you are thinking on the right lines. The formula would be this:
AND(
IsConverted,
OR (
ISBLANK(TEXT(Highest_Education_Level_Completed__c)),
ISBLANK(TEXT( Academic__c )),
ISBLANK(TEXT( Time_Available_for_School__c )),
ISBLANK(Multi_SelectPicklist__c)
)
)
Also, never use "" for checking a blank picklist (not a good practice).
