Skip to main content
SharePoint

Return to Question

added 26 characters in body; edited tags
Source Link
Ganesh Sanap - MVP
Ganesh Sanap - MVP
  • 46.4k
  • 22
  • 31
  • 63

I have two images that are both located in my site assets folder and I want to show the two imagesimages based on when a source column returns "yes" or "no". 

I have a wrapped around a nested if statement and the only results I'm getting is the first image, "yes.png". Even if the source column displays "no" the calculated column returns the "yes.png" image.

Ex. ="<DIV> <IMG src='/SiteAssets/yes.png'"&IF([Source Column]= "Yes", "yes.png",IF([Calculated Column]= "No", "no.png"))&"'> </DIV>Example:

="<DIV> <IMG src='/SiteAssets/yes.png'"&IF([Source Column]= "Yes", "yes.png",IF([Calculated Column]= "No", "no.png"))&"'> </DIV>

And if I leave IMG src as just /SiteAssets/SiteAssets then I only get these  :

curropted image exampleenter image description here

I have two images that are both located in my site assets folder and I want to show the two images based on when a source column returns "yes" or "no". I have a wrapped around a nested if statement and the only results I'm getting is the first image, "yes.png". Even if the source column displays "no" the calculated column returns the "yes.png" image

Ex. ="<DIV> <IMG src='/SiteAssets/yes.png'"&IF([Source Column]= "Yes", "yes.png",IF([Calculated Column]= "No", "no.png"))&"'> </DIV>

And if I leave IMG src as just /SiteAssets then I only get these  curropted image example

I have two images that are both located in my site assets folder and I want to show the two images based on when a source column returns "yes" or "no". 

I have a wrapped around a nested if statement and the only results I'm getting is the first image, "yes.png". Even if the source column displays "no" the calculated column returns the "yes.png" image.

Example:

="<DIV> <IMG src='/SiteAssets/yes.png'"&IF([Source Column]= "Yes", "yes.png",IF([Calculated Column]= "No", "no.png"))&"'> </DIV>

And if I leave IMG src as just /SiteAssets then I only get these:

enter image description here

Source Link
Chief Simz
Chief Simz
  • 11
  • 4

Can I overload a URL to return multiple subfolders in a calculated column?

I have two images that are both located in my site assets folder and I want to show the two images based on when a source column returns "yes" or "no". I have a wrapped around a nested if statement and the only results I'm getting is the first image, "yes.png". Even if the source column displays "no" the calculated column returns the "yes.png" image

Ex. ="<DIV> <IMG src='/SiteAssets/yes.png'"&IF([Source Column]= "Yes", "yes.png",IF([Calculated Column]= "No", "no.png"))&"'> </DIV>

And if I leave IMG src as just /SiteAssets then I only get these curropted image example