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.

mceclip0.png

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:

Strict

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.

Symbol

Text Value

Screenshot

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

Star

  • true (selected state in yellow)

  • false (non-selected in gray)

mceclip1.png

Flag

  • true (selected state in red)

  • false (non-selected in gray)

  mceclip0.png

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

RYG

Red, Yellow, Green

mceclip2.png

RYGB

Red, Yellow, Green, Blue

mceclip0.png

RYGG

Red, Yellow, Green, Gray

mceclip1.png

RYGBG

Red, Yellow, Green, Blue, Gray

mceclip5.png

Harvey Balls

Empty, Quarter, Half, Three Quarter, Full

mceclip12.png

3 State Arrows

Down, Sideways, Up

mceclip11.png

4 State Arrows

Down, Angle Down, Angle Up, Up

mceclip13.png

5 State Arrows

Down, Angle Down, Sideways, Angle Up, Up

mceclip14.png

Priority—Note priority with single select options.

High Low

High, Low

mceclip15.png

High Medium Low

High, Medium, Low

mceclip3.png

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

Yes Hold No

Yes, Hold, No

mceclip5.png

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

3 Directions

Up, Unchanged, Down

mceclip6.png

4 Directions

Down, Right, Up, Left

mceclip19.png

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

Pain scale

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

mceclip20.png

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.