+ Start a Discussion
Bogdan PascuBogdan Pascu 

Help on image formula

Hi I have this formula which is working fine. Now I would like to include in the formula this line

IMAGE( IF( pba__SystemHasClosedClosing__c  = True , "http://firstmallorca.force.com/static/resource/listingstatus/Closing.png",""), "")

Can you please help me to onclude this line in to the formula. 

Also this picklist value shoul be condioned only if pba__SystemHasClosedClosing__c  = False

IMAGE( 
CASE( pba__Status__c , 
"In Acquisition", "http://firstmallorca.force.com/static/resource/listingstatus/Inpreparation.png", 
"In Preparation", "http://firstmallorca.force.com/static/resource/listingstatus/Inpreparation.png", 
"Active", "http://firstmallorca.force.com/static/resource/listingstatus/Active.png", 
"Reserved", "http://firstmallorca.force.com/static/resource/listingstatus/Reserved.png", 
"Blocked", "http://firstmallorca.force.com/static/resource/listingstatus/Blocked.png", 
"Rented by FM", "http://firstmallorca.force.com/static/resource/listingstatus/RentedbyFM.png", 
"Rented by competitor", "http://firstmallorca.force.com/static/resource/listingstatus/Rentedbycompetitor.png", 
"Rented privately", "http://firstmallorca.force.com/static/resource/listingstatus/Rentedprivately.png", 
"Sold by FM", "http://firstmallorca.force.com/static/resource/listingstatus/SoldbyFM.png", 
"Sold by competitor", "http://firstmallorca.force.com/static/resource/listingstatus/Soldbycompetitor.png", 
"Sold privately", "http://firstmallorca.force.com/static/resource/listingstatus/Soldprivately.png", 
"Withdrawn/Archived", "http://firstmallorca.force.com/static/resource/listingstatus/Withdrawnarchived.png", 
"/s.png"), 
"status color")
Best Answer chosen by Bogdan Pascu
Prashanth SamudralaPrashanth Samudrala
Hey Bogdan, 

Here try this, I did not have time to test it - Let me know how it works.
 
IF(
pba__SystemHasClosedClosing__c  = True, 
	IMAGE("http://firstmallorca.force.com/static/resource/listingstatus/Closing.png","pba__SystemHasClosedClosing__c  = True",200,200),
		IMAGE( 
			CASE( pba__Status__c , 
					"In Acquisition", "http://firstmallorca.force.com/static/resource/listingstatus/Inpreparation.png", 
					"In Preparation", "http://firstmallorca.force.com/static/resource/listingstatus/Inpreparation.png", 
					"Active", "http://firstmallorca.force.com/static/resource/listingstatus/Active.png", 
					"Reserved", "http://firstmallorca.force.com/static/resource/listingstatus/Reserved.png", 
					"Blocked", "http://firstmallorca.force.com/static/resource/listingstatus/Blocked.png", 
					"Rented by FM", "http://firstmallorca.force.com/static/resource/listingstatus/RentedbyFM.png", 
					"Rented by competitor", "http://firstmallorca.force.com/static/resource/listingstatus/Rentedbycompetitor.png", 
					"Rented privately", "http://firstmallorca.force.com/static/resource/listingstatus/Rentedprivately.png", 
					"Sold by FM", "http://firstmallorca.force.com/static/resource/listingstatus/SoldbyFM.png", 
					"Sold by competitor", "http://firstmallorca.force.com/static/resource/listingstatus/Soldbycompetitor.png", 
					"Sold privately", "http://firstmallorca.force.com/static/resource/listingstatus/Soldprivately.png", 
					"Withdrawn/Archived", "http://firstmallorca.force.com/static/resource/listingstatus/Withdrawnarchived.png", 
					"/s.png"), 
					"status color")
)

Cheers,
Prashanth

All Answers

Prashanth SamudralaPrashanth Samudrala
Hey Bogdan, 

Here try this, I did not have time to test it - Let me know how it works.
 
IF(
pba__SystemHasClosedClosing__c  = True, 
	IMAGE("http://firstmallorca.force.com/static/resource/listingstatus/Closing.png","pba__SystemHasClosedClosing__c  = True",200,200),
		IMAGE( 
			CASE( pba__Status__c , 
					"In Acquisition", "http://firstmallorca.force.com/static/resource/listingstatus/Inpreparation.png", 
					"In Preparation", "http://firstmallorca.force.com/static/resource/listingstatus/Inpreparation.png", 
					"Active", "http://firstmallorca.force.com/static/resource/listingstatus/Active.png", 
					"Reserved", "http://firstmallorca.force.com/static/resource/listingstatus/Reserved.png", 
					"Blocked", "http://firstmallorca.force.com/static/resource/listingstatus/Blocked.png", 
					"Rented by FM", "http://firstmallorca.force.com/static/resource/listingstatus/RentedbyFM.png", 
					"Rented by competitor", "http://firstmallorca.force.com/static/resource/listingstatus/Rentedbycompetitor.png", 
					"Rented privately", "http://firstmallorca.force.com/static/resource/listingstatus/Rentedprivately.png", 
					"Sold by FM", "http://firstmallorca.force.com/static/resource/listingstatus/SoldbyFM.png", 
					"Sold by competitor", "http://firstmallorca.force.com/static/resource/listingstatus/Soldbycompetitor.png", 
					"Sold privately", "http://firstmallorca.force.com/static/resource/listingstatus/Soldprivately.png", 
					"Withdrawn/Archived", "http://firstmallorca.force.com/static/resource/listingstatus/Withdrawnarchived.png", 
					"/s.png"), 
					"status color")
)

Cheers,
Prashanth
This was selected as the best answer
Bogdan PascuBogdan Pascu
Hi Prashanth,

Many thanks for your help, It is working fine. 

Best regards,
Prashanth SamudralaPrashanth Samudrala
Great! 

Can you mark the above answer as the best answer so that it will be visible to all. 

Cheers,
Prashanth
www.autorabit.com