You need to sign in to do that
Don't have an account?
Dorel Nasso 9
Help with a conditional image formula field
I am trying to create a image field flagging when an opportunity is behind schudule. I am using the stage field and a custom field of "# of days in Process" in the formula. The Days field is also a formula from when the opportunity is received. I can get the formula to work with the first condition but I can not add other stages to the formula.
IF(AND (ISPICKVAL ( StageName, "Received"), of_Days_in_Process__c <= 2), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(AND (ISPICKVAL ( StageName, "Strategy"), of_Days_in_Process__c <= 3), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(AND (ISPICKVAL ( StageName, "Devlopment"), of_Days_in_Process__c <= 5), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(AND (ISPICKVAL ( StageName, "Assembly"), of_Days_in_Process__c <= 6), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)))
I keep getting error message for ",", IF, And. Please advise what I am doing wrong.
Thank you,
Dorel
IF(AND (ISPICKVAL ( StageName, "Received"), of_Days_in_Process__c <= 2), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(AND (ISPICKVAL ( StageName, "Strategy"), of_Days_in_Process__c <= 3), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(AND (ISPICKVAL ( StageName, "Devlopment"), of_Days_in_Process__c <= 5), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(AND (ISPICKVAL ( StageName, "Assembly"), of_Days_in_Process__c <= 6), IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)))
I keep getting error message for ",", IF, And. Please advise what I am doing wrong.
Thank you,
Dorel
CASE(StageName,
'Received', IF(of_Days_in_Process__c <= 2 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
'Strategy', IF(of_Days_in_Process__c <= 3 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
'Devlopment', IF(of_Days_in_Process__c <= 5 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
'Assembly', IF(of_Days_in_Process__c <= 6 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30))
All Answers
IF(ISPICKVAL ( StageName, "Received"),
If(of_Days_in_Process__c <= 2, IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(ISPICKVAL ( StageName, "Strategy"),
IF(of_Days_in_Process__c <= 3, IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(ISPICKVAL ( StageName, "Devlopment"),
IF(of_Days_in_Process__c <= 5,
IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IF(ISPICKVAL ( StageName, "Assembly"),
IF(of_Days_in_Process__c <= 6,
IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30))
))))
Thanks!
Error: Invalid Data.
Review all error messages below to correct your data.
Incorrect number of parameters for function 'IF()'. Expected 3, received 2 (Related field: Formula)
Raj V, Thank you for your formula. The formula saves but no images show in the field.
Try this ..
Refer this line ..
https://help.salesforce.com/articleView?id=000007604&type=1
Hi Dorel,
Please hit this url and please verify if you are seeing that image.
https://PutYourOrgDomainNameHere.com/servlet/servlet.FileDownload?file=0151F000000A3BF
Hi Dorel,
I see you are using a same image for all the TRUE Conditions and another for FALSE Condition, so I took the liberty to shorten your formula.
You can use this formula:
IF( OR(ISPICKVAL(Stagename, "Received") && TotalOpportunityQuantity <= 2,
ISPICKVAL(Stagename, "Strategy") && TotalOpportunityQuantity <= 3,
ISPICKVAL(Stagename, "Devlopment") && TotalOpportunityQuantity <= 5,
ISPICKVAL(Stagename, "Assembly") && TotalOpportunityQuantity <= 6
),
IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),
IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)
)
*Replace TotalOpportunityQuantity with your custom field name i.e 'of_Days_in_Process__c'
Note: If you want to have a different image for each opportunity stage then formula will be different.
Let me know if it helps
Thanks!
CASE(StageName,
'Received', IF(of_Days_in_Process__c <= 2 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
'Strategy', IF(of_Days_in_Process__c <= 3 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
'Devlopment', IF(of_Days_in_Process__c <= 5 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
'Assembly', IF(of_Days_in_Process__c <= 6 , IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30),IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BN",'Red', 30, 30)),
IMAGE("/servlet/servlet.FileDownload?file=0151F000000A3BF",'Green', 30, 30))