When you use conditions, you can define rules so that any record meeting certain conditions will automatically receive a certain color.
To color your records using a single select field, first click the Color option in the view bar, then choose Conditions.
When you first open the conditions dialog, it will have one color and one undefined condition. Each color represents a set of conditions a record can meet (or not meet) and therefore requires at least one defined condition.
Setting up a condition for a color is a lot like applying a filter: you'll need to select a field, an operator, and a comparison value or values.
To add another condition for a color, click on the Add condition button. Once a color has more than one condition, you can also set the boolean operator between conditions to AND or OR.
Clicking on the color swatch for a set of conditions will bring up a color picker with all of the Pro plan colors. From this color picker, you can specify the color for a set of conditions.
Not sure where to start with defining colors and conditions? Here are just a few ideas:
- Color tasks that are overdue and not marked as complete an alarmingly bright red
- Color tasks that have a due date within the next three days and are not marked as complete an eye-catching bright yellow
- Color completed tasks with a neutral gray, making other records stand out in comparison
To add a new color (and associated set of conditions for that color), click the + Add color option at the bottom of the dialog.
Alternatively, you can duplicate a color and all its conditions by clicking the duplicate button next to a color. (This makes it easier to quickly create lots of conditions that are similar to one another.)
Colors' conditions will automatically collapse to save space as you add more colors and conditions, but you can expand a color to view or edit its conditions by clicking on it.
A record can only have one color—so in the case of a record which matches multiple conditions, that record will receive the color of the first condition it matches, starting from the top of the conditions list.
You can rearrange the colors and their associated conditions by clicking and dragging on a color's drag handle. This will change the priority of the different colors—colors closer to the top of the list of colors will get higher priority than those closer to the bottom of the list.
You can also specify a fallback color by clicking the Add fallback color option. Any records not meeting the specified conditions for any of the other colors will get the fallback color.
To remove a condition, click the X next to that condition.
To remove a color (and all its associated conditions), click the trash icon next to the color.
If you're a Pro or Enterprise plan user with creator permissions and you want to ensure that your preferred record coloring conditions won't get accidentally changed, you can lock the view, which will prevent all collaborators from altering a view's configuration until it's been unlocked by someone with creator permissions.