Kanban board, Task tracker, Productivity, Spreadsheet, Google sheets

Welcome to Somaka Kanban Board for Google Sheets!

With this tool, you can effectively organize your tasks by dividing them into different boards that you create. It then analyzes your data and provides a comprehensive overview of your work, offering clarity and insight into your tasks and progress.

Make a copy

To utilize the template, you will need to make a copy first. Simply navigate to the “File” tab and click on “Make a Copy.” The template consists of five main sections:

Kanban Board: This section allows you to organize and track your tasks using the Kanban method, providing visual representation of task progress and stages.

Calendar: In this section, you can view your tasks and deadlines in a calendar format, helping you to plan and manage your schedule effectively.

Dashboard: The dashboard section provides a consolidated overview of your tasks, progress, and key metrics, enabling you to assess your productivity and make informed decisions.

Database: Here, you can store and manage your task data, making it easy to track and retrieve information as needed.

Settings: The settings section allows you to customize and configure various aspects of the template to suit your preferences and specific requirements.


Let’s begin by exploring the settings.

In the settings section, you can configure various aspects of your work, including:

  • Work status: Here, you can define your different work statuses, such as “In Progress,” “Completed,” or any other relevant statuses specific to your workflow.
  • Team members: You can add and manage team members, assigning tasks to individuals and tracking their contributions.
  • Board sections: This allows you to create and customize different sections on the Kanban board, enabling you to organize tasks based on specific categories or project stages.
  • Priority levels: You can set priority levels for your tasks, such as “High,” “Medium,” or “Low,” to ensure efficient task management.

Additionally, you have the option to modify the overdue settings and adjust the date format according to your preferences.

Now, let’s input some data.

To begin, let’s create a new status section. We’ll name it “Q&A 2.” This section will help us track tasks related to quality assurance.

Next, let’s add a new team member to the system. This will allow us to assign tasks and collaborate effectively.

Once you have entered the necessary data, you can proceed to the database section. Here, you can manage and access your task data efficiently, helping you stay organized and informed throughout your work process.


This is the section where you input your tasks. You can specify the relevant category or section to which the task belongs and determine its status and priority level. Additionally, you have the option to assign a responsible person, set start and finish dates, specify a due date, track progress percentage, and record working hours.

Let’s add a new task to the system. Once the task is added, you can set the progress level to reflect the current status of the task. As you complete the task, you can change the status to “Done.” In this case, since the job is complete, let’s set the progress level to one hundred percent.

Kanban Board

After you have finished working with the database, you can proceed to check the Kanban board. The Kanban board presents your tasks in the correct order, allowing you to visualize and manage them effectively. Furthermore, you have the option to apply various filters to the Kanban board.

You can filter tasks based on their priority level, allowing you to focus on high-priority tasks first. Additionally, you can filter tasks by the responsible person assigned to them, ensuring clear accountability and delegation. Another filtering option is to filter tasks by their due date, helping you prioritize tasks based on their deadlines. Moreover, you can filter tasks by their overdue status, making it easier to identify and address tasks that are past their due dates.

The colors of each task on the Kanban board vary according to their priority level. This visual distinction allows for quick identification and prioritization of tasks based on their importance.

By utilizing the Kanban board and its filtering capabilities, you can efficiently manage and track your tasks, ensuring a streamlined workflow and effective task prioritization.


If you have added additional stages in the settings, you can click here to incorporate new stages. Once you have created tasks assigned to those stages, they will automatically appear in this section. You can easily track the progress of tasks within each stage.

In case a task becomes overdue, it will be highlighted in yellow with an overdue indicator, drawing your attention to its delayed status.

Now, let’s move on to the dashboard section.


In this section, you can access the analysis of your data and customize filters, similar to the Kanban board section. Lastly, there is the calendar section, where you can view all your tasks organized by their start date, end date, and due date. You have the flexibility to select the specific month and year you want to view.

Similar to the other sections, you can set filters in the calendar section to refine the tasks displayed based on your preferences.

Elevate Your Life with the Digital Life Planner

Are you prepared to take control of your life and unlock your full potential? Our meticulously crafted Digital Life Planner is specifically designed to assist you in setting and accomplishing your goals, evaluating the balance in your life, effectively managing projects, visualizing tasks on a Kanban board, and elevating your productivity to unprecedented levels.

Key Features:

  • Master Goal Setting: Effortlessly outline your short-term and long-term goals, ensuring a clear path towards success and personal growth.
  • Comprehensive Wheel of Life Assessment: Analyze the equilibrium in key areas of your life, pinpoint where to allocate your efforts, and achieve complete satisfaction and fulfillment.
  • Excellence in Project Planning: Streamline the planning and management of your projects, establish milestones, allocate resources, and monitor progress for optimal project outcomes.
  • Organizational Power of Kanban Boards: Optimize your workflow, boost efficiency, and stay impeccably organized by visually representing your tasks through the powerful Kanban method.
  • Unleash Your Productivity Potential: Utilize our intuitive Google Sheets template to effectively organize tasks, prioritize tasks, and escalate your productivity to unprecedented heights.

Embark on a transformative journey of self-improvement, project triumph, and unrivaled productivity with our Digital Life Planner. Start setting goals, assessing your life, planning projects, and revolutionizing your productivity today!

In Conclusion

In conclusion, the Digital Life Planner proves itself to be an indispensable tool for individuals seeking to unlock their true potential and transform their lives. Through its various features including goal setting, Wheel of Life assessment, project planning, Kanban board organization, task tracking, and integration with Google Sheets, this ultimate tool empowers users to streamline their productivity and achieve optimal results.

By harnessing the power of technology, the Digital Life Planner offers a seamless and versatile platform for individuals to manage their personal and professional goals effortlessly. Whether it is breaking down objectives into actionable tasks, tracking progress, or visualizing priorities on a Kanban board, this tool ensures that users stay focused and organized.

Moreover, the integration with Google Sheets not only provides users with a familiar and accessible interface but also enables seamless collaboration and real-time updates. This feature further enhances the planner’s functionality and makes it a valuable asset for individuals seeking to foster productive teamwork and efficient project management.

Furthermore, the Wheel of Life assessment offers a holistic approach to self-reflection and self-improvement. By evaluating various aspects of life, users can gain valuable insights into areas that require attention and take proactive steps towards achieving a balanced and fulfilling lifestyle.

Overall, the Digital Life Planner not only offers a comprehensive set of tools for goal setting and project management but also encourages users to tap into their full potential. By harnessing the power of technology, this tool empowers individuals to unleash their creativity, efficiency, and productivity, ultimately transforming their lives and achieving their highest aspirations. So, unlock your potential today and embark on a journey of personal and professional growth with the Digital Life Planner.

Leave a Comment

Your email address will not be published. Required fields are marked *

Shopping Basket
Scroll to Top