validation rule to prompt user to select a picklist field - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
John KennedyJohn Kennedy 

validation rule to prompt user to select a picklist field

Hi All,

I have two custom fields. one is a date time field and the other a picklist option.
I'd like that when "Start Date" is picked then the user must select a picklist option.

Any ideas?

John
Best Answer chosen by John Kennedy
Usman AliUsman Ali
Hi John,

Try this formula..
AND
(
	NOT(ISBLANK(DatetimeField__c)),
    ISBLANK(TEXT(PiclistFIeld__c))
)

 

All Answers

Keiji OtsuboKeiji Otsubo
Hi John,

Try this

AND(
ISBLANK(Start Date),
ISBLANK(TEXT(picklist ))
)
 
Usman AliUsman Ali
Hi John,

Try this formula..
AND
(
	NOT(ISBLANK(DatetimeField__c)),
    ISBLANK(TEXT(PiclistFIeld__c))
)

 
This was selected as the best answer
Steve MolisSteve Molis
AND(
RecordType.Name = "X",
NOT(ISBLANK( Start_Date__c)),
ISBLANK(TEXT( PicklistFieldName__c)),
)

 
John KennedyJohn Kennedy
Thanks fellas!
Piyush SinghalPiyush Singhal
Hi John,
you can try this formula:

AND
(
    NOT(ISBLANK(Date__c)),
    ISBLANK(TEXT(Picklist__c))
)