This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
