By Alex Sherwood aka aNotioneer

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

</aside>

🎬 Demo

👨‍🏫 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)) + "%"