Sign Up ›
  • David Palmquist
  • NEWBIE
  • 0 Points
  • Member since 2018
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
2 replies

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! 
2 replies

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!