What’s new?
Select and Multiselect option enhancements
Happy holidays! Today we launched the ability to define Select and Multiselect options from a Named range or a manually selected Range of cells from any worksheet in the current workbook. Similar to data validation in traditional spreadsheets, this allows you to more easily share options between columns and ranges of Select and Multiselect cells using the same data as options.
The new Source field in the Select and Multiselect data type dialog provides three different choices for how options are defined, as shown below:
- List of options (default): Allows you to manually define a set of options with sort and re-order capabilities.
- Range of cells: Allows you to select a range of cells, from any worksheet in the workbook, to use as options. You have the ability to change colors for each option, but the sort order cannot be changed and is based on the order of cells in the range.
- Named range: Allows you to select a Named range, from any worksheet in the workbook, to use as options. You have the ability to change colors for each option, but the sort order cannot be changed and is based on the order of cells in the range.
For more details see our help center articles on the Select and Multiselect data types.