{"id":6468,"date":"2020-07-23T12:45:38","date_gmt":"2020-07-23T10:45:38","guid":{"rendered":"https:\/\/lacolmenatecnologica.com\/how-to-create-a-progress-bar-in-notion\/"},"modified":"2026-09-02T19:33:18","modified_gmt":"2026-09-02T17:33:18","slug":"how-to-create-a-progress-bar-in-notion","status":"publish","type":"post","link":"https:\/\/lacolmenatecnologica.com\/en\/how-to-create-a-progress-bar-in-notion\/","title":{"rendered":"How to Create a Progress Bar in Notion"},"content":{"rendered":"\n

Visual progress bars offer a quick snapshot of a process\u2019s status, improve aesthetics, and provide a subtle source of motivation. They\u2019re not really a native Notion feature, but we can achieve them by combining special characters with a few Notion functions\u2014and the result looks great. <\/p>\n\n

\nhttps:\/\/vimeo.com\/441429597\n<\/div>
Click the PLAY button to watch the video<\/figcaption><\/figure>\n\n
<\/div>\n\n

Required functions<\/h2>\n\n

To create progress bars, we\u2019ll use these three functions.<\/p>\n\n

slice(text<\/span><\/em>, number<\/span><\/em>, number<\/span><\/em>)<\/h3>\n\n

The slice()<\/span><\/em> function returns a segment (or part) of the text we provide. This function needs at least two parameters, though we can optionally use three: <\/p>\n\n

  1. Original text we\u2019re going to extract a part from.<\/li>
  2. Starting point, where the first character is 0<\/span><\/code>.<\/li>
  3. End point (optional)<\/li><\/ol>\n\n

    Example 1:<\/em> slice(\"La Colmena Tecnol\u00f3gica.\", 3, 10)<\/span><\/code><\/strong> \u2192 “Colmena”<\/p>\n\n

    Example 2:<\/em> slice(\"La Colmena Tecnol\u00f3gica.\", 11, 22)<\/span><\/code><\/strong> \u2192 “Tecnol\u00f3gica”<\/p>\n\n

    \"\"<\/figure><\/div>\n\n

    Whitespace also counts as a character. Unlike the start point, the end-point parameter does not include the character<\/strong>, so to include the final character you must set the position to the one right after it.<\/p><\/blockquote>\n\n

    <\/div>\n\n

    round(number<\/span><\/span><\/em>)<\/h3>\n\n

    The round()<\/span><\/em> function rounds a given decimal number to the nearest integer.<\/p>\n\n

    Example 1:<\/em> round( 3.2 )<\/span><\/code> \u2192 3<\/span><\/p>\n\n

    Example 2:<\/em> round( 3.5 )<\/span><\/code> \u2192 4<\/span><\/p>\n\n

    <\/div>\n\n

    format(value<\/span><\/span><\/em>)<\/h3>\n\n

    The format()<\/span><\/em> function converts a given number or date into a text string.<\/p>\n\n

    Example:<\/em> format( 20 )<\/span><\/code> \u2192 \"20\"<\/span><\/code><\/p>\n\n

    Percentage property<\/h2>\n\n

    To visualize your progress, you first need to calculate it as a percentage in a separate property.<\/p>\n\n

    For each project in your database, you may have one property for the total units required to complete it, then another property for the units currently completed.<\/p>\n\n

    In a Progress %<\/em> property, we divide the completed units by the total units:<\/p>\n\n

    \"Notion
    Table with a property formatted as a percentage<\/figcaption><\/figure>\n\n

    prop(\"Unidades completadas\") \/ prop(\"Unidades totales\")<\/span><\/code><\/p>\n\n\n\n

    Here you can see how to remove unsightly decimals in a formula that returns a percentage. <\/p>\n\n\n\n

    \"Notion
    With percentage rounding<\/figcaption><\/figure>\n\n\n\n

    round(100 * prop(\"Unidades completadas\") \/ prop(\"Unidades totales\")) \/ 100<\/span><\/code><\/p>\n\n\n\n

    Special characters to create our progress bar<\/h2>\n\n

    The progress bar will include special characters to represent completed and incomplete segments. While you can choose whatever you like, here are a few suggestions: <\/p>\n\n

    • Shaded blocks \u2192 \u2593\u2591<\/li>
    • Stars \u2192 \u2605\u2606<\/li>
    • Circles \u2192 \u25cf\u25cb<\/li><\/ul>\n\n
      \"Notion
      Table with a progress bar property<\/figcaption><\/figure>\n\n

      With the Progress %<\/strong> property created and the special characters chosen, we can now create the progress bar. Create a new Formula property, name it Progress, and then add this formula: <\/p>\n\n

      Code with shaded characters<\/h3>\n\n

      slice(\"\u2593\u2593\u2593\u2593\u2593\u2593\u2593\u2593\u2593\u2593\", 0, round(prop(\"Progreso %\") * 10)) + slice(\"\u2591\u2591\u2591\u2591\u2591\u2591\u2591\u2591\u2591\u2591\", 0, 10 - round(prop(\"Progreso %\") * 10)) + \" \" + format(round(prop(\"Progreso %\") * 100)) + \"%\"<\/span><\/code><\/p>\n\n

      Code with star characters<\/h3>\n\n

      slice(\"\u2605\u2605\u2605\u2605\u2605\u2605\u2605\u2605\u2605\u2605\", 0, round(prop(\"Progreso %\") * 10)) + slice(\"\u2606\u2606\u2606\u2606\u2606\u2606\u2606\u2606\u2606\u2606\", 0, 10 - round(prop(\"Progreso %\") * 10)) + \" \" + format(round(prop(\"Progreso %\") * 100)) + \"%\"<\/span><\/code><\/p>\n\n

      Code with circle characters<\/h3>\n\n

      slice(\"\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\u25cf\", 0, round(prop(\"Progreso %\") * 10)) + slice(\"\u25cb\u25cb\u25cb\u25cb\u25cb\u25cb\u25cb\u25cb\u25cb\u25cb\", 0, 10 - round(prop(\"Progreso %\") * 10)) + \" \" + format(round(prop(\"Progreso %\") * 100)) + \"%\"<\/span><\/code><\/p>\n\n

      You just need to replace the symbols in the formula with the ones you like best.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

      Visual progress bars offer a quick snapshot of a process\u2019s status, improve aesthetics, and provide a subtle source of motivation. They\u2019re not really a native Notion feature, but we can achieve them by combining special characters with a few Notion functions\u2014and the result looks great. Required functions To create progress bars, we\u2019ll use these three […]<\/p>\n","protected":false},"author":7,"featured_media":6469,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"How to Create Visual Progress Bars in Notion","_seopress_titles_desc":"Learn how to create visual progress bars in Notion using formulas, percentages, and special characters to track your projects at a glance.","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_seopress_news_disabled":"","_seopress_video_disabled":"","_seopress_video":[],"_seopress_pro_schemas_manual":[],"_seopress_pro_rich_snippets_disable_all":"","_seopress_pro_rich_snippets_disable":[],"_seopress_pro_schemas":[],"footnotes":"","_bricks_page_content_2":[],"_bricks_page_header_2":[],"_bricks_page_footer_2":[]},"categories":[381],"tags":[382,383],"class_list":["post-6468","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-notion","tag-databases-in-notion","tag-productivity"],"_links":{"self":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts\/6468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/comments?post=6468"}],"version-history":[{"count":1,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts\/6468\/revisions"}],"predecessor-version":[{"id":6470,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts\/6468\/revisions\/6470"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/media\/6469"}],"wp:attachment":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/media?parent=6468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/categories?post=6468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/tags?post=6468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}