You need to sign in to do that
Don't have an account?
David 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!
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!
Company, Email).
Thanks & Regard,
Sitanshu