function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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)