You need to sign in to do that
Don't have an account?
Bogdan 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")
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")
Here try this, I did not have time to test it - Let me know how it works.
Cheers,
Prashanth
All Answers
Here try this, I did not have time to test it - Let me know how it works.
Cheers,
Prashanth
Many thanks for your help, It is working fine.
Best regards,
Can you mark the above answer as the best answer so that it will be visible to all.
Cheers,
Prashanth
www.autorabit.com