Available Symbols in the Symbols Column

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. 

TIP: 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([% Complete]5 = 1, "Full", "Empty") )

You cannot add your own (custom) symbols to the column.

Who can use this capability

Permission requirements icon People with Owner or Admin (you must have a license) permissions to the sheet can to add or edit a column.

Plan availability icon All plan types.


Available Symbols

SymbolText values (use these to detect symbols in formulas)Looks like this

Flag

NOTE: You can't add a star or flag to a row unless at least one other cell in the row contains data.

  • Flag   
  • Star 

Priority
  • High, Low   
  • High, Medium, Low   

Decision
  • Yes, Hold, No   
  • Yes, Hold, No   
  • Stop, Rewind, Play, Fast Forward, Pause   
Status
  • Red, Yellow, Green   
  • Red, Yellow, Green, Blue   
  • Red, Yellow, Green, Gray   
  • Sunny, Partly Sunny, Cloudy, Rainy, Stormy   
  • Empty, Quarter, Half, Three Quarter, Full   
  • Empty, Quarter, Half, Three Quarter, Full   
  • Down, Sideways, Up   
  • Down, Angle Down, Angle Up, Up   
  • Down, Angle Down, Sideways, Angle Up, Up 
Direction
  • Up, Unchanged, Down   
  • Down, Right, Up, Left  
Measure
  • Easy, Intermediate, Advanced, Expert Only   
  • Empty, Quarter, Half, Three Quarter, Full   
  • Empty, One, Two, Three, Four, Five   
  • Empty, One, Two, Three, Four, Five   
  • Empty, Quarter, Half, Three Quarter, Full   
  • Empty, One, Two, Three, Four, Five   
  • Empty, One, Two, Three, Four, Five   
  • No Pain, Mild, Moderate, Severe, Very Severe, Extreme
Measure Symbols
Was this article helpful?
YesNo