+ Start a Discussion
FIROZ RAYAPATI 9FIROZ RAYAPATI 9 

IF I SELECT HYDERABD IS THE VALUE IN THE PICKLIST FIELD THEN THE CHECKBOX IS NOT LEAVE BLANK

Best Answer chosen by FIROZ RAYAPATI 9
Sainath VenkatSainath Venkat
try this one too I haven't tested but anone of these two will work
 
AND(
OR(
ISPICKVAL(Location__c,"Hyderabad"),
ISPICKVAL(Location__c,"Chennai"),
ISPICKVAL(Location__c,"Bangalore")),
ISBLANK(TEXT(Area__c)))

 

All Answers

Sainath VenkatSainath Venkat
@Firoz,

try below validation rule which will work for your requirement,
 
AND(
ISPICKVAL( Rating ,"Hot"),
Checkbox__c= FALSE)
replace Rating to picklist field and checkbox__c to checkbox field name in your org.

Mark it best if it solves your rpoblem
 
FIROZ RAYAPATI 9FIROZ RAYAPATI 9
THANK YOU SO MUCH SAINATH FOR HELPING ME
FIROZ RAYAPATI 9FIROZ RAYAPATI 9
SORRY FOR ASKING ANOTHER QUESTION ,
  I HAVE TWO PICKLIST FIELDS LOCATION AND AREA, IF I SELECT LOCATION IS HYDERABD OR BANGELORE OR CHENNAI THEN I SHOULD NOT LEAVE AREA FIELD IS BLANK WHAT IS THE VALIDATION RULE GOING TO APPLY
Sainath VenkatSainath Venkat
try below one
AND(
OR(TEXT(Location__c) = "Hyderabad",TEXT(Location__c) = "Chennai",TEXT(Location__c) = "Bangalore"),
ISBLANK(TEXT(Area__c))
)
Sainath VenkatSainath Venkat
try this one too I haven't tested but anone of these two will work
 
AND(
OR(
ISPICKVAL(Location__c,"Hyderabad"),
ISPICKVAL(Location__c,"Chennai"),
ISPICKVAL(Location__c,"Bangalore")),
ISBLANK(TEXT(Area__c)))

 
This was selected as the best answer
FIROZ RAYAPATI 9FIROZ RAYAPATI 9
THANK YOU SO MUCH BROTHER IT IS WORKING BUT I HAVE ONE SMALL DOUBT I WRITE THE CODE ALMOST SAME BUT I MISS THE ONE LINE,
               ISBLANK(TEXT(AREA__C))  THIS IS RIGHT , BUT I WRITE THIS         ISBLANK(AREA__C)   
TEXT WORD IS IMPORTANT IT IS IMPORTANT WHY CAN YOU EXPLAIN ME 
Sainath VenkatSainath Venkat
ISBLANK can be used only for text fields or number field but in your case, Area__c is a picklist field, so we should not use ISBLANK, USING TEXT(Area__c) we are getting text value from picklist and using ISBLANK we are checking whether the text value thatw e got from picklist is null or not
FIROZ RAYAPATI 9FIROZ RAYAPATI 9
OK THANK YOU SO MUCH BRO 
new user 80new user 80
Check This Pagli Status (https://gohappyfriendsday.blogspot.com/2019/09/pagli-Status.html). Hope you Love it.