![]() ![]() If(prop("Hours completed") / prop("Hours allocated") = 0, "❌", if(smallerEq(prop("Hours completed") / prop("Hours allocated"), 0.1), "■ " + format(round(prop("Hours completed") / prop("Hours allocated") * 100)) + "%",""))Īdd outputs for each tier that needs another ■ to indicate progress:Īlthough you can't see all of the spaces, either on this page or in the formula editor, we've added 31 spaces before the ❌ and ✅ emoji, plus enough spaces after each of the progress blocks to align the emoji and text in the progress column. ![]() "■ " + format(round(prop("Hours completed") / prop("Hours allocated") * 100)) + "%"Īdd ■ number & % as output if "Hours completed" is greater than 0 and less than or equal to 0.1: ![]() We found that Notion inverts the colour of this symbol in dark mode so you will have to use White Square, rather than Black Square.īut it's possible that most people reading this aren't using dark mode, I've used Black Square in this guide. The easiest way to insert the squares on a Mac is from the character picker. If(prop("Hours completed") / prop("Hours allocated") = 0, "❌" ,"") Round(prop("Hours completed") / prop("Hours allocated") * 100)įormat(round(prop("Hours completed") / prop("Hours allocated") * 100))įormat(round(prop("Hours completed") / prop("Hours allocated") * 100)) + "%"Īdd if statement & output if "Hours completed" is empty or zero: Prop("Hours completed") / prop("Hours allocated") * 100 Demo: How your progress bar will change with your data ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |