You need to sign in to do that
Don't have an account?
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
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
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)
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.
Figured out the image issue - wrong url