You need to sign in to do that
Don't have an account?
Sain
How do i write a Formula using a Picklist?
Hi,
I have two objects called object1, object2(Master) and having lookup relationship among them, In object1 having a field called test1 and in Object2 having fields test2(piclist values are A,B), test3(picklist values x,y).
Now i am creating a validation rule on object1 to make test1 field mandatory while test2 is 'A' and test3 is 'x'
AND(ISPICKVAL(object1__r.test2__c='A'),ISPICKVAL(object2__r.test3__c='x') )
Getting below error:
Field test2__c is a picklist field. Picklist fields are only supported in certain functions.
and also changed my expression with TEXT but still i am not able to sove it.
AND(TEXT(ISPICKVAL(object1__r.test2__c='A'))
Any suggestions from community.
Thanks in advance.
I have two objects called object1, object2(Master) and having lookup relationship among them, In object1 having a field called test1 and in Object2 having fields test2(piclist values are A,B), test3(picklist values x,y).
Now i am creating a validation rule on object1 to make test1 field mandatory while test2 is 'A' and test3 is 'x'
AND(ISPICKVAL(object1__r.test2__c='A'),ISPICKVAL(object2__r.test3__c='x') )
Getting below error:
Field test2__c is a picklist field. Picklist fields are only supported in certain functions.
and also changed my expression with TEXT but still i am not able to sove it.
AND(TEXT(ISPICKVAL(object1__r.test2__c='A'))
Any suggestions from community.
Thanks in advance.
ISPICKVAL(object1__r.test2__c, “xyz”)
Note that "xyz" or the String literal should be in double quotes. Both parameters should be separated by a comma and you can't use equals operator.
If this resolves your problem, please mark it as Resolved.
All Answers
ISPICKVAL(object1__r.test2__c, “xyz”)
Note that "xyz" or the String literal should be in double quotes. Both parameters should be separated by a comma and you can't use equals operator.
If this resolves your problem, please mark it as Resolved.
Please try with below code it will help !
Thnaks
Manoj