No Code Column Formatting in SharePoint – NEW

There’s a new wizard based, easy user interface for column conditional formatting in SharePoint Online!!  That means you don’t have to know JSON code in order to do some conditional formatting on your columns!!!!!!

This doesn’t work on every column type, there are still limitations, but it does give some basic options.

Right now this only works on these types of columns:

  • Date
  • Choice
  • Yes/No (boolean)

It’s pretty simplistic.  There are only a few ways you can format them, so if you need to do anything more complex than what you see out of box, you can still use JSON.

Here’s how the new formatting works.

Click the heading of a column, click Column settings, and choose Format this column.  The one in this example, Status, is a choice column.

format-this-column

In the panel on the right side of the screen, the panel will have the name of your column at the top.  Mine says Format Status column, because I selected the column called Status.  You can click the checkbox to turn on some generic, default colors, or you can click Edit Template, to configure further.  To do formatting with code instead of this wizard, click Advanced mode.

format-status-column

On this next screen, for a choice column, you’ll see a list of all the choices that exist for that column, with a little color palette icon next to each.

format-column-colors

Click a color palette, and you’re presented with a set of (fairly limited) colors to pick from.  You can even choose No fill if you’d like.

column-color-palette-picker

Configure each color if you’d like, and click Apply.  At any time, click Reset to default style, to remove the conditional formatting.

For a date column, the choices are a little different. A date column will only give you three choices.  By default, each one in relative to today, but you can click the drop-down on each, to change it to a specific date instead.

format-date-column

For a Yes/No boolean column, it’s only going to have two choices obviously, one color for Yes, and one color for No.

Here’s mine with a couple of choice columns, a date, and a yes/no, all formatted:

all-formatted-columns-sharepoint

After formatting the columns, it’s still possible to see the code and tweak it if you’d like.

Go to list/library settings, and click the name of a column.  Scroll down to see the Column Formatting box, and dig in.

json-column-formatting

That’s it for now, happy conditional formatting!  Also, if you’d like to learn about this and more, check out my SharePoint Power User course!

Related Resources:

SharePoint Power Hour: Column Formatter

SharePoint Column Formatter – GitHub

SharePoint List Formatting – GitHub

 

14 comments

Leave a reply or question

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.