+ Start a Discussion
Romil Gupta 6Romil Gupta 6 

Can any one solve my problem??

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
Best Answer chosen by Romil Gupta 6
Parker EdelmannParker Edelmann
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

All Answers

Rikshit RawatRikshit Rawat
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')

 
Dilip_VDilip_V
Hi Romil,  

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

Thats it.

Thanks,
Dilip.
Parker EdelmannParker Edelmann
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
This was selected as the best answer