Skip to main content
Topics#Data ManagementSwarnpalli Das's Question
Swarnpalli Das asked in #Data Management
May 24, 2018, 1:15 PM

Formula for displaying image based on picklist values?

Hello! everyone!

 

I need the formula to change icon based on picklist values.

 

Thanks in advance.
3 answers
  1. Ajay Dubedi (Ajay Dubedi)
    May 25, 2018, 6:34 AM
    Hi Swarnpalli,

     

    You can try the below formula for displaying image based on picklist values:

     

    IMAGE(

     

      IF(ISPICKVAL(XXXX__c, "Picklist 1"), "Image_URL",

     

          IF(ISPICKVAL(XXXX__c, "Picklist 2"), "Image_URL",

     

              IF(ISPICKVAL(XXXX__c, "Picklist 3"), "Image_URL"),

     

                  IF(etc....))

     

    )

     

    )

     

    Replace XXXX__c with your custom field name.

     

    Please mark it best if you find it helpful.

     

    Thank you,

     

    Ajay Dubedi

     

     
Write an answer...
0/9000