Set multiple choices as default values for checkbox fields in SharePoint forms

1–2 minutes

default checks

I recently worked on a project for a client that needed 2/3 checkbox options checked by default on a new form. While not as straight-forward as other field types, it’s still certainly possible.

  1. Go to List –> List Settings (server/on-prem) or settings wheel –> List Settings (online/O365)
    list settings
    list settings o365
  2. Click the name of your checkbox/choice column to edit its settings or create a new checkbox column
    iexplore_2018-07-26_07-53-51
  3. Change “Default value:” from “Choice” to “Calculated Value”
    iexplore_2018-07-26_07-52-49
  4. Enter a formula like: =”;#Choice;#Choice;#Choice;#”
    Example:
    =”;#Printed Statement;#E-Statement;#Pick Up in Office;#”
  5. Click OK

That’s it! Now on new forms/items, everything you entered in the formula as a default choice will be pre-checked.
pre-checked


Discover more from Nate Chamberlain

Subscribe to get the latest posts sent to your email.

One response to “Set multiple choices as default values for checkbox fields in SharePoint forms”

  1. Larry Lapeyrouse Avatar
    Larry Lapeyrouse

    I keep getting this error when I switch from Choice to Calculated Value:
    Sorry, something went wrong
    The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.

    The column name is correct: Checked in/out
    with this formula:
    =”;#Checked-in;#Checked-out;#”

Leave a Reply

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

Discover more from Nate Chamberlain

Subscribe now to keep reading and get access to the full archive.

Continue reading