Text Widget on monday.com: How to add custom text
[fact_box]
**Interesting Use:** The Time Tracking Widget can also be used to track time spent working on creative projects like writing a book or developing an app. This allows you to see how much time was spent on each stage of the project and helps you manage your time more effectively.
[/fact_box]
How to Add the Widget To add a widget to your dashboard, click the “Add widget” button in the top left corner of the dashboard login page, as shown below. In the Widget Center, search for and select the ‘Time Tracking’ widget. Note: The Time Tracking widget is based on the Time Tracking Column, so you must first enter the time you tracked in the column before we can see the data displayed in the widget. You should check out this article to learn how to set this up.
How to set it up
In the top right corner of your Widget, click on the three dots and select the “Settings” option from the drop-down menu. From the panel on the right side of the settings window that opens, you can configure your Time Tracker Widget with fully customizable settings! Let’s go through all the settings categories together!
Boards and groups
First, under ‘Boards’, we can select up to 5 boards that we want to see in our widget, and under ‘Choose groups’, we can choose which groups we want to display data from. We’ve only selected one board to display in the Time Tracking widget. Our board represents all the dogs we take for walks at our dog walking company, and uses the Time Tracking column to track how long their walks are, making sure everyone gets the right amount of exercise! Each group is a different walk time, ranging from weekday mornings, afternoons, and evenings, to weekend mornings and evenings. Each item is one of our clients (the puppies, of course!) We assign a walker to each dog using the People Column and indicate what day of the week the walk will take place in the Status column.
[note_box]
**Smart Use:** If you have a large team, consider using a people column to assign walkers to each dog. This will help you keep track of who is responsible for each walk and ensure there is no confusion.
[/note_box]
Time tracking
If you have more than one time tracking column, choose which ones you want to display in your widget under ‘Time Tracking’. Next, choose how you want to group the time you’ve tracked. You can group them by each column on your boards! In the example below, we’ve grouped the time we’ve tracked by a Status column, showing us the Totals of the time our dog walkers have walked each day of the week. In the example below, we’ve chosen to group the time we’ve tracked by a People column. This way, we can see how much time was allocated in total under items assigned to each person. Below, we’ve chosen to group the time we’ve tracked by Time Tracking Sessions. This way, we can see how much time was actually logged by each person, regardless of who was assigned to that item. For example, this week Leah was supposed to walk 6 dogs, which adds up to about 6 hours of walking. She couldn’t make it to one of her walks this week, so she asked Kayla to replace her! So in this case, the grouping by people column shows the scheduled trips, while the grouping by time tracking sessions shows the physical trips! This is very helpful for both the employer and the employee when it comes to billing hours!
More setting options
Next, under ‘More settings options’, we can choose a time period! Here, we choose whether we want to see all the time allocated in a day, week, month, or even a year! We selected “Weeks” in the example below, and we can use the arrows to move back and forth in our calendar to view different weeks! We can also optionally trigger an alert when a group reaches its threshold! At our company, we want our dog walkers to try to stay under 8 hours of walking per week, so we set our threshold at 8 hours. Next, we chose the color red to highlight the time allocated that has crossed our threshold. As you can see below, Lindia walked for almost 10 hours this week, exceeding our threshold by almost 2 hours! Now we’ll know to pay attention to this next week so everyone stays under the threshold.
[note_box]
**Note:** If you see someone going over the threshold you set, it could be a sign of overload. It’s worth checking to see if the work needs to be divided differently.
[/note_box]
Note: The Time Tracking Widget can also be added to the board view, however, the configuration options in this view may differ slightly from the dashboard view.
Choose how to display the widget
Once we have finished mapping our settings, we can choose how we would like this widget to be displayed on our dashboard! We can display it as: “Time Tracking” which only shows the total time allocated from our boards
“Table” which shows the time groups allocated across all our boards as they will appear on each one. This is a great option if you want to track time across multiple boards and need to glance at them all at once
“Split Mode” (as seen in the image below) that connects the two views so you can see the totals along with the original data!
Filter the allotted time
If we don’t want to see a summary of all the information on our board, we can click the filter icon to filter our information! When billing hours, we take weekends into account and the easiest way to do this is to filter the weekend walks by dog walker! In the image below, we’ve filtered by groups, selecting “Weekend Morning Walk” and “Weekend Evening Walk”, and then filtered by one of our dog walkers to see how many hours she walked last weekend! If we want to return to this view the next time we open our dashboard, we can click ‘Save filter’, in the top right corner, and our widget will remain with this filter until we click ‘Clear’ in our filter menu.
Time tracking summary
Want to see a summary of the times tracked across both items and sub-items on your board? Currently, the Time Tracking widget will only show the total times of your items and not the sub-items. However, as always, we have the simplest solution for you.
By adding a Formula Column to your board, you can create a quick solution to see the total time summary tracked across both your items and subitems.
[note_box]
**Useful Formula:** Use a formula column to summarize the time for items and subitems. This can help you get a complete picture of the time spent on each project.
[/note_box]
Create a summary of the main item
First, you’ll need to create a summary of the subitem, on the parent item, to reflect the time tracking column from your subitems. Select the three dots inside your subitem’s time tracking column, and from the drop-down menu, select “Show summary on parent item.”
Add a formula column
You can then add the formula column to your board which, once set up with the exact formula, will allow you to summarize the subitem time tracking data. Select the “+” icon to the right of your last column to create a new column and select “Formula Column” from the drop-down menu. Enter the following formula in the formula box that appears and select the blue “Set Formula” button: DIVIDE(SUM({Subitems Time Tracking}, {Time tracking}),3600)
Create a new chart
Within your board view or dashboard, create a new chart. To access the chart settings, select the three dots in the upper right corner of the widget. Under the “X Axis” settings, select “Name” to display for the column type. Under the “Y Axis,” select “Formula” under the column type. The data displayed in the chart will now show you the summary of the time tracking across both your items and subitems.