+ Start a Discussion
Hitesh KhannaHitesh Khanna 

I want to display an image if both fields ("abc__c" and "xyz__c") are populated. even if one of them is blank image should not be displayed.

I wrote this. But its not wokrking if one of the fields is blank(but working if both are blank). what changes should i make ?
IF(
AND(NOT(ISBLANK( abc__c )) , NOT(ISBLANK( xyz__c ))) ,


IMAGE("/servlet/servlet.ImageServer?id=0150R000001JUkT&oid="+$Organization.Id, "icon" ,24, 128),
""
)

 
Best Answer chosen by Hitesh Khanna
Abdul KhatriAbdul Khatri
Hi Hitesh,

In you formula field where you placing that logic, below there is an option

User-added image

I hope this help.

All Answers

Abdul KhatriAbdul Khatri
Hi Hitesh,

Do not see any issue with the code? What is the data type of the fields?
Hitesh KhannaHitesh Khanna
Hi Abdul,

Currency fields
Suraj Tripathi 47Suraj Tripathi 47

Hi,

Can you try like this

IF(
AND((abc__c!=null),(xyz__c!=null)),
IMAGE("/servlet/servlet.ImageServer?id=0150R000001JUkT&oid="+$Organization.Id, "icon" ,24, 128),
""
)
Please mark it as the best answer if it works
Hitesh KhannaHitesh Khanna
Hi suraj
No its not working
Abdul KhatriAbdul Khatri
Hi Hitesh,

In you formula field where you placing that logic, below there is an option

User-added image

I hope this help.
This was selected as the best answer
45 Track45 Track
yes, it's also not working on my website. (https://45track.com/)