function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
David PalmquistDavid Palmquist 

USE TEXT FORUMLAS

I keep failing the Syntax Check for my Lead_Quality_Helper.  

IF(ISBLANK(Company), 0, 1)+ 
IF(ISBLANK(Title), 0, 1)+ 
IF(ISBLANK(Email), 0, 1)+ 
IF(ISBLANK(Phone), 0, 1)+ 
IF(ISPICKVAL(Industry,""), 0, 1)

i'm getting the error  Error: Formula result is data type (Number), incompatible with expected data type (true or false).

and if I change it to false, true 
I get this error: 
 Error: Incorrect parameter type for operator '+'. Expected Number, Date, DateTime, received Boolean. 

IF(ISBLANK(Company), false, true)+ 
IF(ISBLANK(Title), false, true)+ 
IF(ISBLANK(Email), false, true)+ 
IF(ISBLANK(Phone), false, true)+ 
IF(ISPICKVAL(Industry,""), false, true)


Am I missing something?  Any help is greatly appreciated.  Thanks! 
David PalmquistDavid Palmquist
NVM.  I figured it out.  I was writing a Validation Rule instead of a formula
Sitanshu TripathiSitanshu Tripathi
I am not understanding why you are creating a formula field if the Lead object have Required Field (
Company, Email).

Thanks & Regard,
Sitanshu