Forum Discussion

Alan Trafford's avatar
Alan Trafford
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...
Matthew DiLiberto's avatar
Matthew DiLiberto
Brass Contributor
Jan 27, 2019

Depending on how your data is structured, you may want to restructure your data so that you can use the "Choice" column type to assign metadata to each record. This will simplify your overall implementation. It will also prevent user error and variations within "Single Line of Text" data entries. i.e. "On Hold" vs "OnHold" vs "On-Hold".

 

More recently, there is also a no-code solution for Choice, Date/Time, and Boolean column types that does not require knowledge of complex JSON to assign background colors.

https://www.technologytobusiness.com/microsoft-sharepoint/no-code-column-formatting-sharepoint-online

 

This approach assumes 1 choice option for each variation between "On Hold - Awaiting customer" or "On Hold - Awaiting Vendor" respectively. You can define up to 24 color options at the moment.

Resources