By Alex Sherwood aka aNotioneer

<aside> ⚠️ If you're viewing this page in Presstige.io, click here to see the original.

</aside>

🎬 Demo

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/bbcac899-0a31-4626-b2d0-341cf3175474/Notion_Progress_Formula_demo_3.gif

👨‍🏫 Guide


📖 Notion formula reference guide


Formula example

🧱 Building the formula step by step

<aside> 🚨 If you get an error message about a ‘syntax error’ when copying and pasting these formulas, try copying the ‘Unformatted formula’ from the toggle list instead.

</aside>

% calculation:

prop("Hours completed") / prop("Hours allocated") * 100

Round the % to the nearest whole number

round(prop("Hours completed") / prop("Hours allocated") * 100)

Convert to text:

format(round(prop("Hours completed") / prop("Hours allocated") * 100))

Add % symbol:

format(round(prop("Hours completed") / prop("Hours allocated") * 100)) + "%"