function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Scott ChesworthScott Chesworth 

IF Formua Text Field Is Blank

Hi, Im am trying to show an image if a formula text field is not blank. I have acheived the desired reult with another object based on a checkbox been false but cannot replicate based on a blank vale in the text formula field. So far i have this:

IF(
NOT(ISBLANK(Special_Instructions__c)),
IMAGE( "/servlet/servlet.FileDownload?file=015D0000003l2n5", "SPECIAL INSTRUCTIONS"),
IMAGE( "/servlet/servlet.FileDownload?file=015D0000002Fpg4", "NO INSTRUCTIONS"))

Any sugestions would be greatly appreciated. Thanks.
JayantJayant
This should resolve your problem - 

Just replace the field 'Special_Instructions__c' with the formula for 'Special_Instructions__c'.

IF(
NOT(ISBLANK([Formula for Special_Instructions__c])),
IMAGE( "/servlet/servlet.FileDownload?file=015D0000003l2n5", "SPECIAL INSTRUCTIONS"),
IMAGE( "/servlet/servlet.FileDownload?file=015D0000002Fpg4", "NO INSTRUCTIONS"))

------------------
If this resolves your problem, please mark the question as Resolved.
Muralidhar S (Salesforce)Muralidhar S (Salesforce)
Scott,

ISBLANK(field) returns true if the field is blank and so you need to remove the NOT i.e it should be as below

IF(ISBLANK(Special_Instructions__c),
IMAGE( "/servlet/servlet.FileDownload?file=015D0000003l2n5", "SPECIAL INSTRUCTIONS"),
IMAGE( "/servlet/servlet.FileDownload?file=015D0000002Fpg4", "NO INSTRUCTIONS"))