Ben SmithBen Smith
Ben Smith/
Gauge Chart
Gauge Chart
Gauge Chart

Gauge Chart

For
JH
From
Twitter
Status
Updating
Formulas
+
+
/
/
empty
empty
floor
floor
format
format
if
if
>=
>=
*
*
replaceAll
replaceAll
round
round
slice
slice
-
-
Share

Gauge Chart

if(empty(prop("Progress")), "", if(prop("Progress") >= 1, "✅✅✅✅✅✅✅✅✅✅  100%", "🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩  " + format(round(prop("Progress") * 1000) / 10) + "%\n" + replaceAll(slice("xxxxxxxxxx", 1, floor(prop("Progress") * 10)), "x", "⬜️") + "🔼" + replaceAll(slice("xxxxxxxxx", 0, 10 - floor(prop("Progress") * 10)), "x", "⬜️")))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!