You need to sign in to do that
Don't have an account?
Regina200
Help with text formula to show an image when two conditions are met
Hi, I've never studied coding or developing, so I'm having a bit of trouble figuring this out. Basically what I want my formula text to do is, if the Days Since Last Update field > 90 AND if Stage Name does not equal Closed Won or Closed Lost, show an image of a red exclamation point so that users know this opportunity needs to be reviewed.
Here is the formula I am using: IF(AND(Days_Since_Last_Update__c > 90), IMAGE ("/servlet/servlet.FileDownload?file=015j0000000PsCZ","Red:High Importance"),null)
The only issue is, I'm not sure how to insert the piece about if the Stage Name (which is a picklist) equals Closed Won / Closed Lost, the red image does not have to be shown and the opportunity does not have to be reviewed.
Thank you so much for your help!!
Here is the formula I am using: IF(AND(Days_Since_Last_Update__c > 90), IMAGE ("/servlet/servlet.FileDownload?file=015j0000000PsCZ","Red:High Importance"),null)
The only issue is, I'm not sure how to insert the piece about if the Stage Name (which is a picklist) equals Closed Won / Closed Lost, the red image does not have to be shown and the opportunity does not have to be reviewed.
Thank you so much for your help!!
I have created the formula field with mentioned criteria and its works fine for me.
Below are the screen-shots for Valid and Invalid criteria:
Valid Criteria (If our formula field meets our criteria), it will show red banner
Invalid criteria, It will show yellow color banner:
I belive this helps you! Please let me know if you have any queries or help.
Thanks,
Prem Anandh
All Answers
Try the above, basically it is saying IF Days > 90 & Stage Name is not equal to Closed Lost OR Closed Won then show the picture. Otherwise null.
Try this, you cannot have an IF statement inside of an OR but I think you can have an OR statement inside of an IF.
I am so grateful for your help!!
I have created the formula field with mentioned criteria and its works fine for me.
Below are the screen-shots for Valid and Invalid criteria:
Valid Criteria (If our formula field meets our criteria), it will show red banner
Invalid criteria, It will show yellow color banner:
I belive this helps you! Please let me know if you have any queries or help.
Thanks,
Prem Anandh
Prem--Thank you for the formula!! Totally got what I needed.
FYI, We can use static resource to populate image in formula field. So We no need to hardcode the Id's
Thanks,
Prem Anandh
show in error