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.
- Go to List –> List Settings (server/on-prem) or settings wheel –> List Settings (online/O365)
- Click the name of your checkbox/choice column to edit its settings or create a new checkbox column
- Change “Default value:” from “Choice” to “Calculated Value”
- Enter a formula like:Â =”;#Choice;#Choice;#Choice;#”
Example:
=”;#Printed Statement;#E-Statement;#Pick Up in Office;#” - Click OK
That’s it! Now on new forms/items, everything you entered in the formula as a default choice will be pre-checked.
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;#”