A Single Select column type is used when there is a set of options available and the user can choose any one from the set like selecting a city that a person lives in or designation of an employee.

You can add options to the Single Select column type by using either Static Data or Functions. To add using Static Data simply type the option and press enter to go to the next one.

To use the the function open the function panel and use the following syntax:

[“Option 1”,”Option 2”,Option 3]

You can use the sort option to sort the rows from first to last or last to first based on the value of this column. Read more about sort here.

Each option can be assigned colors to make the visualization of the sheet better. You can assign these colors by clicking the colors option in the column properties and then selecting a color.

Did this answer your question?