With your Progress (Percent) property created and your creative characters determined, you’re ready to create your progress bar. Your progress bar will include creative characters to represent completed and uncompleted segments of your bar.

Within Calculate, choose Percentage checked.

Choose the Checkbox field that indicates the task is complete.

Therefore, you can add a Rollup property that automatically calculates the percentage of tasks completed for the project: If you follow the Bulletproof Workspace methodology your Projects database is linked to your Tasks database.

In a Progress (Percentage) property, you can divide the completed units by the total units: prop( 'Completed Students' ) / prop( 'Total Students' ) Rollup Total Unitsįor each project in your database, you might have a property for total units required for completion, then another property for currently completed units.įor example, a school photographer might have a database of classes, with properties for Total Students and Completed Students. You have many ways of doing so here are two: Completed Units vs. To visualize your progress, you first need to calculate it as a percentage within an independent property.

The format() function converts a provided number to a text string.Įxample: format( 20 ) → '20' Your Percentage Property The round() function rounds the provided decimal number to the nearest integer.

The test expression, which evaluates to true or false.Įxample: if( 2 < 3, 'Yes', 'No' ) → 'Yes' Comparison Operatorsįor the first argument - the test expression - you can use comparison functions, such as test() or comparison operators, which you’ll find in The Notion Formula Cheat Sheet.

By nesting if() functions, or placing them within one another, you can specify actions for numerous conditions. The if() function allows you to perform an action if a condition is met, or another action if the condition is unmet.

The starting point, where the first character is 0.Įxample: slice( 'Into the ocean.', 9, 14 ) → 'ocean' if().

The slice() function returns a segment of a provided text string. If you’re new to formulas, consider starting with Meet Notion’s Formula Property. To create your progress bars, you’ll use the three below functions.

By pairing creative characters with a few Notion functions, you can create beautiful, inspiring progress bars to bolster your workspaces. Dissect it for a better understanding of Notion, or simply copy the contents.Īs you track your projects in Notion, visual progress bars offer a quick snapshot of your progress, an aesthetic enhancement, and a subtle source of motivation. The guide details the development of the Notion VIP Progress Bars template.

Notion widgets progress bar