Assigning Select and Multiselect Values with Formulas

In Spreadsheet.com, values in Select and Multiselect columns can be assigned with formulas just like any other text strings.

Many of Spreadsheet.com's unique data types like the Select and Multiselect data types can be assigned via formulas. Combining formulas with the Select or Multiselect data types allows you to create complex logic to determine which select values to assign, or even have your worksheets change select options based on changes to data in other worksheets.

How to Input Formulas in Select and Multiselect Cells

You can create formulas in Select and Multiselect cells the same way you would input a formula anywhere else – by typing it directly in the cell or by using the formula bar above the worksheet header.

In order to use formulas in Select and Multiselect cells, Strict must be turned off.

The names of Select and Multiselect options are referenced in formulas like all other text strings, placed between quotation marks. And, like all other text strings, they can be used in compound formulas and those that involve conditional logic. When referencing Select or Multiselect options, make sure they're input in your formula exactly as they appear in the list of options.

In the example below, we use an Ifs statement to assign one of three Select options – "Not Started", "In Progress", and "Complete" – based on a "% Complete" value in an adjacent column. Cells with 0% complete are assigned "Not Started", those with 100% complete are assigned "Complete", and all others are assigned "In Progress".

Select-Value-With-Formula.png

As you would expect from other formulas, formulas in Select and Multiselect cells are dynamic. For example, if we were to change Cell B2 in the example above to 100%, Cell C2 would update to the "Complete" Select option.

To learn more about other data types that can use formulas to assign values, check out the rest of our Advanced formatting and assigning values with formulas articles. Or, take a look at our articles on the Select and Multiselect data types for more information on those data types.