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
tulasiram chtulasiram ch 

Error: Incorrect parameter type for function 'AND()'. Expected Boolean, received Text AND(Last_Name__c, OR(ISBLANK(Phone__c), ISBLANK(Email__c) ) ) ...Any one help me why i am getting this error

Error: Incorrect parameter type for function 'AND()'. Expected Boolean, received Text 

AND(Last_Name__c,
       OR(
             ISBLANK(Phone__c),
             ISBLANK(Email__c)
            )
       ) ...Any one help me why i am getting this error
Shashikant SharmaShashikant Sharma
Hi,

In this formula you are using Last_Name__c in AND function.

AND(Last_Name__c,
       OR(
             ISBLANK(Phone__c),
             ISBLANK(Email__c)
            )
       ) 

AND Function: AND Function has paramters having Expression returning Boolean values. Like you have provided for ISBLANK(Phone__c) and ISBLANK(Email__c) . You have to make the first parameter as an Expression returning Boolean value. Like below

  
AND(ISBLANK(Last_Name__c),
       OR(
             ISBLANK(Phone__c),
             ISBLANK(Email__c)
            )
       )


 
sagarika bsagarika b
Hi ,

Normally 'AND()' Function Expecting  Boolean Values only,
Last_Name__c Is not a Boolean value right; it is a string, for this reason, we are getting an error message.

Please check with below code once 
AND(ISBLANK(Last_Name__c),
       OR(
             ISBLANK(Phone__c),
             ISBLANK(Email__c)
            )
       )

Hope It helps you

BestRegrads
Sagarika
​