<aside> <img src="/icons/info-alternate_gray.svg" alt="/icons/info-alternate_gray.svg" width="40px" /> Notion Formulas 2.0 offer a new way to track project progress without using rollups using the new map() function. This can be useful for complex projects with nested tasks, or for projects where you need more control over how progress is calculated.

</aside>

<aside> <img src="/icons/code_gray.svg" alt="/icons/code_gray.svg" width="40px" /> Example

Sub-Tasks Example

</aside>

Copy the code

if(!prop("Sub-item").empty(), 
	floor(100 *
		prop("Sub-item").map(
			current.prop("Done").toNumber()
		).sum() / 
		prop("Sub-item").length()
	) / 100,
	prop("Done").toNumber()
)

if(!prop("Sub-item").empty(),
	floor(100*
		prop("Sub-item").filter(
			current.prop("Status") == "Completed"
		).length() /
		prop("Sub-item").length()
	) / 100,
	replace(
		prop("Status"), "Completed", "1"
	).toNumber()
)

☕ Buy me a coffee