You need to sign in to do that
Don't have an account?
kjun
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))))
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: Hope this helps! Please mark as best if it answers
Thanks
All Answers
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: Hope this helps! Please mark as best if it answers
Thanks
AND(
NOT(ISNEW()),
ISBLANK(TEXT(Employment__c))
)
Thanks,
Maharajan.C
Try this,
I hope this helps you.