Symbol field type

Would be great to have a symbol field type, similar to these in SmartSheet (column properties); useful for providing visual indication of project status (different from percentage complete).

(I can provide example images via email; your system won’t allow me to add them to this post).


Symbol field type

Welcome to the community, Deb! :smiley: Airtable supports the use of emoji in numerous places, including single/multiple select options, formula output strings, etc. Converting a percentage to some other graphic representation is pretty easy.


The {Stars} formula:

REPT("⭐️", FLOOR(Percent * 5))

The {Bar} formula:

REPT("|", FLOOR(Percent * 20))

The math is needed because percentage fields store values as a decimal number between 0 and 1, so 38% is actually stored internally as 0.38.

You can use much more complex formulas to create much more interesting output but these are some simple examples just to show what’s possible.

1 Like