Icon set

  • Updated

The Icon set data type mceclip1.png is for selecting from a predefined set of symbols. Fill your cells and columns with icons like Red/Yellow/Green status indicators, Harvey Balls to indicate completion, Slate Arrows, Pain Scale faces, and more.


Icon sets are a great way to quickly visualize the status of projects, tasks, bugs, collateral in development, and more. Add icon sets where ever you want to indicate priority, measurements, status, or simply want to flag rows. For instance, use icon sets in your team's bug tracker to note high-priority bugs, use Harvey balls to indicate how far your developers are in their fix, or mark when the submitter agrees the bug has been resolved.

Topics in this Article:


Like other data types, the Icon set data type can have Strict enabled. Selecting the Strict checkbox for Icon set cells will restrict users to input only icons. Also, columns that have Strict enabled cannot have cells of different data types.

Icon Set Options 

Spreadsheet.com currently supports over fifteen different icon sets, as detailed below. You can use icon sets for whatever purpose best suits your needs, but a few possible purposes are suggested below, including symbols as a toggle, status indicator, to indicate priority, decision, etc.


Text Value


Toggle—Users can toggle these icons to represent either a true or false state.


  • true (selected state in yellow)

  • false (non-selected in gray)



  • true (selected state in red)

  • false (non-selected in gray)


Status—Pick a single option to indicate the status of a row.


Red, Yellow, Green



Red, Yellow, Green, Blue



Red, Yellow, Green, Gray



Red, Yellow, Green, Blue, Gray


Harvey Balls

Empty, Quarter, Half, Three Quarter, Full


3 State Arrows

Down, Sideways, Up


4 State Arrows

Down, Angle Down, Angle Up, Up


5 State Arrows

Down, Angle Down, Sideways, Angle Up, Up


Priority—Note priority with single select options.

High Low

High, Low


High Medium Low

High, Medium, Low


Decision—Decision values are rendered as options in a select list.

Yes Hold No

Yes, Hold, No


Direction—Direction values are rendered as options in a select list.

3 Directions

Up, Unchanged, Down


4 Directions

Down, Right, Up, Left


Measure—Indicate pain via faces, by allowing users to choose from a select list.

Pain scale

No pain, Mild, Moderate, Severe, Very Severe, Extreme


Converting data to the Icon set, and between Icon sets

Icon set cell values can be displayed both as the symbol or the matching name (True, False, Red, Yellow, Up, Down, Quarter, Half, Yes, No, No Pain, Mild, etc.) as noted in the table above. 

When converting existing data, if a column, cell, or range of cells are changed to the Icon data type, then any cells with these matching names will convert to the corresponding symbol. For instance:

mceclip1.png  mceclip3.png

Similarly, if you change icon sets, any matching symbols will remain, but all others will be converted to the symbol's text name or emptied. For instance:

mceclip4.png mceclip5.png

You can always revert by selecting undo in the toolbar mceclip0.png or with the keyboard shortcut Ctrl + Z (CMD + Z for Mac users).

Spreadsheet.com also has the Rating data type to indicate ratings between 0 and 10, the Select data type for a custom list of drop-down options, and the Attachment data type to add images and other files in cells. Check out our introduction to data types for more about all of our data types.