'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Microsoft Lists Board View Not Showing Existing Columns
Question details
The user needs to find a way to make missing Choice columns appear in the 'Organize board by' dropdown menu within Microsoft Lists Board view.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Organizing tasks and items in the Board view using existing Choice columns.
- Observed behavior
- Specific Choice columns do not appear in the 'Organize board by' options, even though they exist in the list and contain multiple selections.
Ensure you have the necessary edit permissions for the Microsoft List to modify column settings and adjust view configurations.
Disable Multiple Selections in Column Settings
The Board view does not support Choice columns configured for multiple selections. You must disable this feature to use the column for organizing your board.
Microsoft Lists requires Board view columns to have a single, definitive value to properly categorize items into buckets. If a Choice column allows multiple selections, it is automatically excluded from the 'Organize board by' dropdown menu.
Open your Microsoft List. Locate the Choice column that is missing from the Board view, click on the column header, and select 'Column settings' followed by 'Edit'.
In the edit pane on the right side of the screen, scroll down to 'More options' and toggle the 'Allow multiple selections' setting to 'No'.
Click 'Save' to apply the changes. Refresh the page or reopen the Board view to see the column successfully appear in the 'Organize board by' dropdown.
Manage Your Data Seamlessly with WPS Office
If you are frustrated by view limitations and column restrictions in Microsoft Lists, consider using WPS Spreadsheet as a flexible, lightweight alternative for tracking tasks and organizing data. Enjoy complete format compatibility and powerful data filtering without arbitrary constraints.
- 1. Download WPS Office: Install WPS Office Free on your device to access the versatile Spreadsheet tool.
- 2. Organize Your Data: Create a new spreadsheet or import your existing lists to easily track your items using highly customizable tables.
Frequently Asked Questions
Why does Microsoft Lists Board view hide some of my Choice columns?
The Board view does not support Choice columns that have the 'Allow multiple selections' option enabled. Because items can only exist in one column bucket at a time in Board view, only single-choice columns will appear in the 'Organize board by' menu.
Can I use multiple selection columns in other list views?
Yes, Choice columns with multiple selections enabled will continue to work perfectly and can be viewed or edited in standard List, Gallery, or Grid views.
Is there a limit to how many Choice columns I can have in Microsoft Lists?
While you can create multiple Choice columns in a list, only the ones explicitly configured to allow single selections (no multiple selections) will be recognized by the Board view formatting tool.
