I am trying to create a Red, Green Image of Null formula with two picklist fields. I've tried functions IF,CASE,AND, OR... nothing seems to work - any suggestions?
- IF Field 1 is not blank
- Field 2 is blank, IMAGE RED,
- Field 2 is not blank, IMAGE GREEN,
- Null
I get Syntax errors with Extra ",", Missing ")", but if I have it all "correct" then I get errors on improper functions, ie. Case expected 2, returned 2..... etc. Any help would be appreciated.
This is where I am stuck -
IF (NOT(ISPICKVAL(Q1__c,' '),
ISPICKVAL( Q4__c,' '),
IMAGE("https://c.na4.content.force.com/servlet/servlet.FileDownload?file=01560000001aBcu", "Requires Configuration")),
NOT(ISPICKVAL( Q4__c,' '),
IMAGE ("https://c.na4.content.force.com/servlet/servlet.FileDownload?file=01560000001aBcv ", "Configured"),
NULL)
3 个回答
Hi Vicky, Please give this a shot
IF(ISBLANK(TEXT(Q1__c)), NULL,
IF(ISBLANK(TEXT(Q4__c)),
IMAGE("https://c.na4.content.force.com/servlet/servlet.FileDownload?file=01560000001aBcu", "Requires Configuration"),
IMAGE("https://c.na4.content.force.com/servlet/servlet.FileDownload?file=01560000001aBcv", "Configured")
)
)
