By Alex Sherwood aka aNotioneer
<aside> ⚠️ If you're viewing this page in Presstige.io, click here to see the original.
</aside>
📖 Notion formula reference guide
<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)) + "%"