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.p ng’ 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.p ng’ 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>”,””)))
I would really appreciate anyones help getting me started on how to do this.
=IF(CAI=”Green”,”<img src=’../SiteAssets/Green.p
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.
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
Does this help you?
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?
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 TRIALMembers 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.
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