Sign Up ›
  • Jillian Cook
  • NEWBIE
  • 0 Points
  • Member since 2019
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
2 replies

Formula field to display an image if another field is not blank

I'm trying to create a formula field that will display an image ONLY if another field is not blank. The formula is:

IF(
NOT(ISBLANK(Credit_Voucher_Balance__c)), IMAGE("/servlet/servlet.FileDownload?file=0151P000003Qrc1","Credit Balance"),
" ")

However, the field is displaying the image whether Credit_Voucher_Balance__c (which is a text field) is blank or not. 

Any help is greatly appreciated!


 
2 replies

Formula field to display an image if another field is not blank

I'm trying to create a formula field that will display an image ONLY if another field is not blank. The formula is:

IF(
NOT(ISBLANK(Credit_Voucher_Balance__c)), IMAGE("/servlet/servlet.FileDownload?file=0151P000003Qrc1","Credit Balance"),
" ")

However, the field is displaying the image whether Credit_Voucher_Balance__c (which is a text field) is blank or not. 

Any help is greatly appreciated!