Skip to content

Instantly share code, notes, and snippets.

@davatron5000

davatron5000/gist:1be8d9ad83121548181f5c1077873d9c

Created January 26, 2020 19:06
Show Gist options
  • Save davatron5000/1be8d9ad83121548181f5c1077873d9c to your computer and use it in GitHub Desktop.
Save davatron5000/1be8d9ad83121548181f5c1077873d9c to your computer and use it in GitHub Desktop.
Download ZIP
progress-meter.txt
Raw
gistfile1.txt
if(prop("Completed") / prop("Goal") == 0, "░░░░░░░░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.1), "▓░░░░░░░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.2), "▓▓░░░░░░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.3), "▓▓▓░░░░░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.4), "▓▓▓▓░░░░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.5), "▓▓▓▓▓░░░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.6), "▓▓▓▓▓▓░░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.7), "▓▓▓▓▓▓▓░░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.8), "▓▓▓▓▓▓▓▓░░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.9), "▓▓▓▓▓▓▓▓▓░ ", if(smallerEq(prop("Completed") / prop("Goal"), 0.99), "▓▓▓▓▓▓▓▓▓▓ ", if(prop("Completed") / prop("Goal") == 1, " 🏁", "")))))))))))) + format(round(prop("Completed") / prop("Goal") * 100)) + "%"
@davatron5000
Copy link
Author

davatron5000 commented Jan 26, 2020 •
edited
Loading

Create a Completed number column and a Goal number column and then a Progress Meter formula column with this formula.

The formula is a bunch of nested ternaries like if(boolean, value, ...anotherifstatement() )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment