SOLVED

Not able to display images using calculated column conditionally

Copper Contributor

Hello

 

I am using classic view in SharePoint Online and created calculated column and added formula as mentioned below

=IF([Countdown]>=271,"<IMG src='/test/Images/Valid.GIF"&"'/>",IF([Countdown]>0,"<IMG src='/test/Images/Expiring.GIF"&"'/>","<IMG src='/test/Images/Invalid.GIF"&"'/>"))

 

It is throwing error "The formula contains a syntax error or is not supported". I know this can be done easily in Modern View , but I have to implement in classic view. I am not able to figure out where is the issue.

7 Replies

@Avi65 HTML is no longer supported in calculated column formula in SharePoint online.

 

Some users have added HTML markup or script elements to calculated fields. This is an undocumented use of the feature, and we will block the execution of custom markup in calculated fields in SharePoint Online from June 13, 2017 onwards.

 

DocumentationHandling HTML markup in SharePoint calculated fields 

 

You may need to use client side rendering (CSR) / JSLink for you requirements in classic experience.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Ganesh,

Thanks for the clarification.
I visited the link share by and provided sample url I did not found any jslink sample.

Secondly I did not found jslink in our side, probably it is disable from Admin site, is it possible to enable jslink feature for a particular site collection and their sub sites.

@Avi65 Do you have access to content editor or script editor web part? You can use those as well to inject custom JavaScript on classic pages.

 

Also, check below threads which might help you: 

  1. How to get the Alternative text for "Hyperlink or Picture" field Type in SharePoint online 
  2. Add to Hyperlink to column in SharePoint List using JSLINK - Help 
  3. SharePoint 2013 Client Side Rendering: List Views 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Hello Ganesh

Unfortunately I dont have access of content editor web part, as I mentioned earlier custom scripts is turned OFF!

Is it possible to enable enable custom script for specific site collection?

@Avi65 Check below Microsoft official documentation which has PowerShell command example for enabling it:

 

Allow or prevent custom script 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

I already tried following script, it is throwing error, when I try to implement for sub site level. But Sie collection level, I am not getting error. Seems it wont support for sub site.

$spoadminurl = "https://mytenantdomain-admin.sharepoint.com"
$Spositeurl="https://mytenantdomain.com/sites/workflow-test/newsite"

Connect-SPOService -url $spoadminurl -credential (Get-Credential)
Set-SPOsite $Spositeurl -DenyAddAndCustomizePages 0
best response confirmed by Avi65 (Copper Contributor)
Solution

@Avi65 Yes, it can be enabled at either tenant level or at site collection (site) level.

 

It is not supported for SharePoint sub-site level. So, enable it at site collection level and you should be able to use it at sub-site level.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

1 best response

Accepted Solutions
best response confirmed by Avi65 (Copper Contributor)
Solution

@Avi65 Yes, it can be enabled at either tenant level or at site collection (site) level.

 

It is not supported for SharePoint sub-site level. So, enable it at site collection level and you should be able to use it at sub-site level.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

View solution in original post