Automate Notion with two formulas. Progress Percentage shows completion rates visually. Link Projects to Tasks via a relation. Roll up Total Tasks (Count all) and Completed Tasks (Count Done). Paste: if(Total Tasks > 0 and Completed Tasks == Total Tasks, "100%", if(Status == "backlog" or Status == "on hold", "0%", if(Total Tasks > 0, let(c, if(empty(Completed Tasks), 0, toNumber(Completed Tasks)), t, if(empty(Total Tasks), 0, toNumber(Total Tasks)), p, round(c / t * 100), b,
Lux Seminare
May 315 min read
The Lux Seminare Blog: Your Hub for Peak Productivity