Automations

Synchronize time entered via 7pace with a number column within your monday.com boards. Having a number of worked hours present on items opens many possibilities of how to report time spent on your projects directly within monday.com boards.

How to use Automations?

Automations are the easiest way how to get basic reporting of spent time directly from monday.com boards and dashboards. You don't get breakdown by dates and people, but total number of hours can often be enough to keep track of planned hours vs. tracked hours or to calculate amount to be billed.

For example, you can set up two Number fields on an item:

• 'Hours planned' where you specify number of hours planned for this particular item (that can represent a project, a task, etc.).
• 'Hours spent' that will be filled with a total number of hours actually tracked on this item in 7pace Timetracker.

Then, whenever you track or modify hours in 7pace Timetracker, the 'Hours spent field will be populated with the value from 7pace Timetracker.

Now you have total hours in a monday.com column, you can use it in any way that monday.com provides, such as:

• Projecting total hours to a parent board by using the 'Connect boards' feature and mirroring the 'Hours spent' column.
• Or comparing planned vs. actual hours by utilizing 'Hours planned' and 'Hours spent' columns in dashboard widgets (like in the image, below).

When using Automations, please make sure that your monday.com plan supports a high enough number of actions - the limits are described in monday.com documentation. Even with moderately large boards, you will easily end up with thousands of used actions.

What about subitems?

If you use subitems in your projects and track time on them, you will have to set up the automation twice - once for items, once for subitems. Make sure your subitems contain a numeric column which can be used for synchronization.

Once you have your 'Hours spent' columns in both items and subitems and you synchronize time with these, you should end up with something like this:

But what if you want to see total tracked hours of an item and all its subitems on an item level? You can use some monday magic for that. You will need:

1. A mirror column on an item level that will sumarrize hours spent on subitems. It can be created by clicking on a respective subitem column and selecting 'Show Summary on Parent Item' from the context menu (three dots).
   
2. Then, create a formula column on the item level that will calculate the sum of hours spent on an item and on its subitems. In the image below, notice how 'Total hours spent' calculate the sum of 'Hours spent' (item level) and 'Subitems Hours spent' (summary of subitems).
   

That's it, you're done!

Final notes

Setting up automations may seem a bit complicated, but it can provide your boards and dashboards with the basic information about total tracked time quickly.

If you're tired of setting these up over and over again, we recommend creating a template board and creating new boards by using the template board as a template. In such case, you don't have to set up automations from scratch, but make sure you check if they are working on both subitems and items - several times, we encountered a situation when copied automations did not work at first and had to be re-set. This is out of our control as the automations are handled by monday.com.