+ Start a Discussion
Rachel Z.Rachel Z. 

Validation Rule Not Allowing Me to Use Field

Hi All, I have a validation rule that I would like to create on the campaign stating that a particular field cannot be changed if the campaign has more than 0 leads or opportunities created from it. It wasn't letting me use the standard fields on the campaign so I created my own custom formula adding leads and  opportunities together but I still keep getting the same error.

This is my what seems to be very simple validation rule that will not work.

Total_Inquiries_and_Proposals__c >0

The following is the error I receive:

Error: Error in referenced formula Total_Inquiries_and_Proposals__c, Field NumberOfLeads may not be used in this type of formula
KierenJamesonKierenJameson
This looks awful like this question: https://success.salesforce.com/answers?id=90630000000ZbIaAAK