Sub-Task Progress

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.

Example

 

Checkboxes

Status

Name

Date

Done

Progress (1)

Project A

Oct 18, 2023

Done

Project B

Oct 25, 2023

Done

Project C

Oct 18, 2023

Project D

Oct 30, 2023

Done

Sub-task 1

Done

Sub-task 2

Done

Sub-task 3

Done

Sub-task 4

Done

Sub-task 5

Done

Sub-task 6

Done

Sub-task 7

Done

Sub-task 8

 

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