+ Start a Discussion
prabhat jhaprabhat jha 

without using(ispicklist,isnull,isblank) functions ,

i have one picklist of products and a price field to give price when a product is selected,,
i want to write a validation rule so that when product is selected price have to be given and vice versa ,if product is not selected ,we should not enter price)

can anyone provide me a validation rule for this without using is related functions
Thanks in advance
Prabhat Jha
Lorcan O'ReganLorcan O'Regan
This should work

(LEN(TEXT(Product__c))>0 && LEN(TEXT(Price__c))=0)
||
(LEN(TEXT(Product__c))=0 && LEN(TEXT(Price__c))>0)