Link to home
Start Free TrialLog in
Avatar of Dorinda Reyes
Dorinda Reyes

asked on

PLEASE HELP JSON conditional formatting in SharePoint Online

I am trying to us column formatting in SharePoint Online and am very new to JSON.  I am trying to use conditional formatting based on another column.  This was the code I was using when we could do calculated columns.

I would really appreciate anyones help getting me started on how to do this.

=IF(CAI=”Green”,”<img src=’../SiteAssets/Green.png’ border=’0'/><div style=’font-size: 75%;color: white; position:relative; text-align:center; width: 88px;top:-33px;word-wrap: break-word;’>”&[CAI Vendors]&”</div>”,IF(CAI=”Yellow”,”<img src=’../SiteAssets/Yellow.png’ border=’0'/><div style=’font-size: 75%;color: black; position:relative; text-align:center; width: 88px;top:-33px;word-wrap: break-word;’>”&[CAI Vendors]&”</div>”,IF(CAI=”Red”,”<img src=’..../SiteAssets/Red.png’ border=’0'/><div style=’font-size: 75%;color: white; position:relative; text-align:center; width: 88px;top:-33px;word-wrap: break-word;’>”&[CAI Vendors]&”</div>”,””)))
Avatar of Kyle Santos
Kyle Santos
Flag of United States of America image

Hi,

I am following up on your question.  Do you still need help?

If you solved the problem on your own, would you please post the solution here in case others have the same problem?

Regards,

Kyle Santos
Customer Relations
Avatar of Dorinda Reyes
Dorinda Reyes

ASKER

Still need help and no one responded
Hi Dorinda,

I have not had any luck yet finding an expert so I have reached out to the Microsoft SharePoint community for advice on your problem.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_winother-msoversion_other/please-help-json-conditional-formatting-in/a3d6a6e8-f92d-47bc-b90a-588a7355eba7?tm=1531239473790

As soon as I hear from them I'll update you.
Dorinda,

A member of their community replied with

Hi Kyle,

 

Thanks for joining our forum.

 

As your question is related to SharePoint Online customization, we kindly suggest you post it in TechNet Forum for dedicated support. It is a specific channel handling this kind of queries and questions.
https://social.technet.microsoft.com/Forums/en-US/home?brandIgnore=True&sort=relevancedesc&searchTerm=Json+conditional+formatting+sharePoint
 

Meanwhile, here are some related articles that maybe helpful for you:

Use column formatting to customize SharePoint
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

 

Appreciate your understanding.

 

Regards,

Zixuan

Does this help you?
Hi,

Is there anything else we may be able to assist you with?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.