SharePoint Checkbox Yes and Empty (No) values


Tech Trek – 2014.07.02

PROBLEM —
SharePoint defaults into “No” (false) value when Checkbox column is not selected. A user requested that it will be easier to isolate “Yes” (true) value when having a Checkbox column. This got me into my thinking cap, so why not?

WORKAROUND —
You can create a Choice column instead with only one item e.g. Yes, in order, to display empty values when users doesn’t select a value. Make this an optional column and leave the default value as blank. You can choose whether to use a drop down style, or checkbox to display the control.

Nice and easy …

Advertisements

Leave a Reply

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s