Forum Discussion

Brass Contributor

Feb 01, 2018

Column formatting using JSON

Hi I'm trying to format a column based on a column containing certain text. This column can have multiple values starting with: "On Hold". Example: "On Hold - Awaiting customer" or "On Hold - A...

Tomislav Karafilov

MVP

Feb 01, 2018

Hi,

you can create a new calculated column [ColumnStatus7Characters] using a formula like =LEFT([ColumnStatus], 7) and than you can use the = operator in the JSON for column [Status], but checking column [ColumnStatus7Characters] for "On Hold". Not nice but a Workaround.

Regards

Alan Trafford

Brass Contributor

Feb 01, 2018

Tomislav Karafilov Thanks for the workaround.

I'm still wondering if it is possible just in JSON.

Joel Rodrigues
MVP
Feb 04, 2018
Hi Alan,

I haven't played that much with column formatting so not sure, but give this solution a try as it will massively help you
https://github.com/SharePoint/sp-dev-solutions/tree/master/solutions/ColumnFormatter

Joel
- Alan Trafford
  Brass Contributor
  Feb 05, 2018
  Hi Joel Rodrigues
  
  I was trying for a quick solution using the new Column Formatting feature. Not really wanting to write code unless I have to.
  
  Alan
  - Joel Rodrigues
    MVP
    Feb 05, 2018
    Hi Alan Trafford,
    
    That project is a web part that gives you a friendly interface to build the JSON for column formatting. It also contains a wizard :)
    
    Give it a try :)
    
    Joel