Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
Hi all,

I m trying to create a formula field  but showing error..

can any one help me to crack this this problem.??

Thank you.

User-added image
3 answers
  1. Aug 9, 2016, 4:06 PM

    I think you might want to try this formula instead:

    IF( ISPICKVAL( City__c, "Jaipur"),

      IMAGE( "https://solidwize.com/wp-content/uploads/2012/04/Green-Check-Mark.jpg", "valid", 30, 30),

      IMAGE("https://images.clipartpanda.com/wrong-clipart-red-wrong-cross-md.png" , "invalid", 30, 30))

    Pardon me if I made a typo in the URL to the images, but this formula will work better than a CASE Statement, if it would work at all.

    Regards,

    Parker
  2. Aug 9, 2016, 10:53 AM
    Hi Romil,  

    In your formula expression just replace City__C="Jaipur" with ISPICKVAL(City__c, 'Jaipur')

    Thats it.

    Thanks,

    Dilip.
  3. Aug 9, 2016, 10:38 AM
    Hi Romil,

    For picklist field value comparision, please use "ISPICKVAL" function. Since City__c field is picklist type, it should be

    ISPICKVAL(City__c, 'Jaipur')

     
0/9000