The Symbols column displays an image to convey a meaning. Use a Symbols column to describe the status of a row or to indicate that something needs your attention for follow-up.
You cannot add your own custom symbols to the column.
You can use formulas in a Symbols column. To do this, use the text values of the symbols. For example, to manipulate the value in a Symbols column that uses Status symbols, you might create a formula similar to the following: =IF([Percent Complete]5 = 1, "Full", "Empty"))
The following table list the available symbols, the text values for symbols for use in formulas, and an image of what the symbols look like.
Checkbox column | Text values (use these to detect symbols in formulas) | Looks like this |
---|---|---|
Select the checkbox style when you add the checkbox column to your sheet. |
|
![]() |
Symbol column | Text values (use these to detect symbols in formulas) | Looks like this |
---|---|---|
Priority |
|
|
Decision |
|
|
Status |
|
|
Direction |
|
|
Measure |
|
![]() |