+ Start a Discussion
kjunkjun 

Validation using ISCHANGED and Picklist

I"m trying to create a validation rule when a change to a record is made but the Employment picklist is blank (aka no values have been selected), the user must make a selection in the picklist before saving. I tried this formula but its not working as intended. Any ideas? Thanks
 
AND(
ISCHANGED(Id),
NOT(ISBLANK(TEXT(Employment__c))))

 
Best Answer chosen by kjun
SarvaniSarvani
Hi,

Your formula will not work as you have ischanged(Id) and the formula will never be true.The records "id" will never change once its created.
If your goal is to make user select the picklist value for Employment__c and not allow it to be blank, when the user hits edit record and try saving it back.

Use below formula:
(ISBLANK(TEXT( Employment__c )))
Hope this helps! Please mark as best if it answers

Thanks

All Answers

SarvaniSarvani
Hi,

Your formula will not work as you have ischanged(Id) and the formula will never be true.The records "id" will never change once its created.
If your goal is to make user select the picklist value for Employment__c and not allow it to be blank, when the user hits edit record and try saving it back.

Use below formula:
(ISBLANK(TEXT( Employment__c )))
Hope this helps! Please mark as best if it answers

Thanks
This was selected as the best answer
Maharajan CMaharajan C
If the validation rule have to be fired only on record update then add one more condition as like below:

AND(
NOT(ISNEW()),
ISBLANK(TEXT(Employment__c))
)

Thanks,
Maharajan.C
Tushar JadavTushar Jadav
Hi Kjun,

Try this,
 
ISPICKVAL(Employment__c,"")

I hope this helps you.