Single and Multi-Select fields

Guide

Single and multi-select Fields allow you to pick from one or multiple options. They are available in Formulas and Automations.

Workflow Field is a special kind of single-select Field design to track statuses.

Emoji and color

Choose an emoji and a background color for each option for a nice visualization:

Select & Workflow Fields in Formulas

In Formulas, these Fields are treated like Relations to mini Databases, with additional features and limitations.

Considering this:

A Single-Select Field is a many-to-one Relation to a Database.
A Multi-Select Field is a many-to-many Relation to a Database.

In both cases, the available choice options are the Entities of that Database.

These special Select Databases are not shown in the list of Databases for the Space, but they function in many ways like a normal Database. To access it, Alt + Click on the Select option as shown in the GIF above.

That means these Fields may have different kinds of properties, and in Formulas we have to address which one to use.

Add a numeric values to Select Fields

To use Select Fields in Formulas, you need to add numeric values to them first. Just click … on the Field column, scroll down to Advanced section, and enable Specify numeric values for each option switcher.

Now we are ready to work with Formulas.

Case 1. Mention using name

Let's say we want to have a Formula that calculates the number of Tasks with high priority. We will create this Formula on the Project level.

Here is what the Formula looks like:

Tasks.Filter(Priority.Name = "High").Count()

Similar to what we do when we use Formulas across Relations, right?

Here we go!

Let's check Case 2.

Case 2. Calculate complexity based on a single-select value

Let's say we measure priority based on numbers, not text, just like this:

And at the Project level, you want to know the average complexity across all the Tasks. However, 0-5-10 that are visible on the screenshot are in fact text, not numbers. To use these Single-Select Fields in a Formula, you need to set numeric values to them.

To do that, click … on the Field column, scroll down to Advanced section, and enable Specify numeric values for each option switcher.

Later in the Formula, you can access these Fields as Priority.Value.

Here is what the full Formula looks like:

Tasks.Avg(Priority.Value)

Here we go!

Select Fields in Automations

Set Single- and Multi-Select Fields in Automations

Permissions

Who can add new select options

If Allow anyone to add new options toggle is on, then anyone who can edit entities in the parent Database can add new options. If the toggle is off, the right is reserved for Architects only:

	Toggle on	Toggle off
Submitter	➖	➖
Viewer	➖	➖
Commenter	➖	➖
Editor	✅	➖
Owner	✅	➖
Architect	✅	✅

For example, adding a new Supercritical Priority option in Bugs DB would require at least Editor access to Bugs DB (or its Space) in case the toggle is on and Architect access if the toggle is off.

See Share Database for details about DB access.

Who can add auxiliary Fields in select Database

To create an auxiliary Field inside a single- or multi-select Database, one needs Architect access to the parent Database or its Space.

For example, to create and manage Definition of Done Field for Projects' States, one needs Architect access to Projects DB or Project Management Space.