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
janeisaacjaneisaac 

adding a third parameter to this IF(AND( formula is breaking it - what is wrong?

This formula works:

IF(AND(Question_Group__c="A", Answer__c="Yes"),IMAGE("https://cs2.salesforce.com/015R00000001juO","Yellow"),null)

 

but when I added a third component to the AND portion of the formula, it breaks it

 

IF(AND(Question_Group__c="A", Answer__c="Yes", ISPICKVAL(Status,"Done Not Reviewed"),IMAGE("https://cs2.salesforce.com/015R00000001juO","Yellow"),null))

 

I get the following error message: Error: Incorrect parameter for function 'AND()'. Expected Boolean, received Text.

 

So something about that addition of the pickval component is throwing it off. Does anyone have any suggestions?

 

Thanks,

Jane

Best Answer chosen by Admin (Salesforce Developers) 
janeisaacjaneisaac

SteveMO came to my rescue again but I cannot get the image to appear.

Grr - just a box with a red X and the text.

 

IF(
AND(
Question_Group__c = "A",
Answer__c = "Yes",
ISPICKVAL(Status__c,"Done Not Reviewed")),IMAGE("https://cs2.salesforce.com/015R00000001juO","Yellow"),NULL)

All Answers

janeisaacjaneisaac

SteveMO came to my rescue again but I cannot get the image to appear.

Grr - just a box with a red X and the text.

 

IF(
AND(
Question_Group__c = "A",
Answer__c = "Yes",
ISPICKVAL(Status__c,"Done Not Reviewed")),IMAGE("https://cs2.salesforce.com/015R00000001juO","Yellow"),NULL)

This was selected as the best answer
Steve :-/Steve :-/

Hi Jane where is the image that you're formula is using stored?  Is it in a public or private folder?  Do all users have access to the file?  If both those check out okay, double-check the ID in your IMAGE URL string and make sure that brings you to the image file. 

janeisaacjaneisaac

Figured out the image issue - wrong url