I am trying to make a library that you would just need to put the image and url in and it would create a hyperlinked image that will display on our site. I feel like I'm really close but I'm missing something. I used these instructions here: Adding an image link via calculated column on a list with HTML directory list solution

Basically creating a calculated column which works great! But...I want to be able to put my own picture there. I tried editing the formula to this:

=IF(ISBLANK([Site URL]), "URL Missing", ("<a href="&[Site URL]&"target='_blank' alt='Open site in new window'><img src=[photo url column]' /></a>"))

But that doesn't do the trick. I'm not sure why it won't work. If you have any suggestions, I'd appreciate the assistance!

  • What is your SharePoint version? – little_big_thoughts Dec 22 '17 at 17:14
  • I'm on version 2013 – Natalie Dec 26 '17 at 13:03

The "photo url column" is a column, so that you need to use the following formula.

=IF(ISBLANK([Site URL]),"URL Missing",("<a href='"&[Site URL]&"' target='_blank' alt='Open site in new window'><img src='"&[photo url column]&"'/></a>"))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.