You need to sign in to do that
Don't have an account?
AAI
validation rule doesn´t show a text value
Hi all,
I would need that if a user select a piclist field value, another text field can´t be blank.
Here is my code. Any help, please?
AND (
ISPICKVAL( Status , "Unqualified"),
NOT (ISBLANK( ReasonRejectedByCommercialPlanning__c ))
)
I would need that if a user select a piclist field value, another text field can´t be blank.
Here is my code. Any help, please?
AND (
ISPICKVAL( Status , "Unqualified"),
NOT (ISBLANK( ReasonRejectedByCommercialPlanning__c ))
)
All Answers
I tried with your formula and I got the following error "The Reason rejected must be filled" although the field was filled.
Please Remove NOT, From NOT (ISBLANK( ReasonRejectedByCommercialPlanning__c )),then it will work,you need to fire the message when it is blank or null,but in your code you are firing it on when it is NOT(Blank),so its not working,remove NOT from code it will work.
Is your Rejected Reason a picklist field ? If yes, then you need to use the below formula
The text field is an area text field type.
I don´t know why it doesn´t work.
I will continue trying.
Thanks
Thanks for your answers.
Here is the correct validation rule:
AND (
ISPICKVAL(Status ,"Unqualified"),
ISBLANK( ReasonRejectedByCommercialPlanning__c ))