0

I've been browsing around trying to find out how to display an image within an IF statement on a page without it showing the link as text. Current my list looks like this:

list

with the 'statusimage' formula looking like this:

=IF(Status="Complete","https://website.com/teams/
Business Change/SiteAssets/Images/changelogo.png","Not Run")

How do i change it from showing the link to showing the actual image?

List setup for reference:

enter image description here

0

Did you try this? http://blogs.technet.com/b/jay/archive/2013/06/17/how-to-display-images-in-a-calculated-column-of-a-sharepoint-list.aspx

Hope this will help you.

  • I'd used this before and it helped me some of the way. Thanks for the link :) – Gary Mar 27 '14 at 13:09
0

I figured it out. It seems the trick is in the setup.

The data type at the bottom of the column setup must be changed to 'Number' rather than 'Single line of text'.

The forumla should look like this:

=IF(Status="Complete","<img src=https://website.com/teams/ Business Change/SiteAssets
/Images/changelogo.png>","Not Run")

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.