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
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
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
All Answers
try below validation rule which will work for your requirement,
replace Rating to picklist field and checkbox__c to checkbox field name in your org.
Mark it best if it solves your rpoblem
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
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