For new year, I was thinking about what feature’s of Airtable I never use. I came up with the repeat function REPT(), which takes a string and a number and returns the string repeated x times.

I thought I would try and show this ignored feature some love, and it sent me down an Emoji wormhole. I figured you could use the REPT function along side some emoji’s to make graphs.

The formula to achieve this is really simple. The only trap is ensuring you use an absolute when handling negative numbers as REPT won’t accept negative numbers:

IF(Level>0,REPT("🟩",Level),REPT("🟥",ABS(Level)))&" "&Level

Watch the full video below:

The other formulas I use in the video are:

SUBSTITUTE("....................🌝",".","🚀",Progress)

and:

SUBSTITUTE(SUBSTITUTE("🟥.🟥.🟥.🟥.🟨.🟨.🟨.🟨.🟩.🟩.🟩.🟩.🟨.🟨.🟨.🟨.🟥.🟥.🟥.🟥",".","⬇️",ROUND((Variance*10)+10),0),".","")