Sign Up ›
  • Laxmi Reddy 12
  • NEWBIE
  • 0 Points
  • Member since 2020
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
2 replies

I am trying to create a formula field. But getting error. Below is by syntax

IMAGE (IF( AND( ISPICKVAL( Rating , 'Hot'&&  BillingAddress,'Ban'),'/resource/Green',

IF (ISPICKVAL(Rating , 'Cold'&& BillingAddress,'Hyd'),'/resource/Yellow', 

IF( ISPICKVAL(Rating, 'Warm'&& BillingAddress,'Viz'), '/resource/Red')))))