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 typeWelcome 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.