Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Symbol field type

cancel
Showing results for 
Search instead for 
Did you mean: 
Deb_Woodcock
4 - Data Explorer
4 - Data Explorer

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).

Thanks.

Symbol field type
1 Comment
Justin_Barrett
18 - Pluto
18 - Pluto

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.

40%20AM

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.