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).
Welcome to the community, Deb! :grinning_face_with_big_eyes: 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.
