I wanted to know if there is a possibility to do the following:
I have a board where each employee is supposed to track their time per item (customer / project) in columns for each day (monday through friday.)
Ideally, employees enter the values for each day. Now what I want is a clumn of “total time” and have the values of each day mo-fr automatically added to the (already existing value) in “total time” and then by each weekend, automatically wipe the entries so everyone starts with a clean slate for the next week.
Is it possible for you to share a screenshot of the set up? I might just need a bit more visual context to better understand what you’re trying to achieve From what I can understand, a formula column might help here in summing the total values, but will need to be sure of your board structure!
There is a way to set up a tracking system for employee time per item on a Monday.com board. You want to automate the calculation of total time per week and reset the entries at the end of each week .
1.Create a new column called “Total Time”.
2.Add a formula to the “Total Time” column that sums up the values in the day-specific columns. For example, if your day-specific columns are called “Monday”, “Tuesday”, “Wednesday”, “Thursday”, and “Friday”, the formula would be:
=SUM(Monday, Tuesday, Wednesday, Thursday, Friday)
3.Set up a recurring automation to run on Saturday morning. The automation should clear the values in the day-specific columns
Hi, thanks for your reply. How exactly do I set up the recurring automation to clear the values? I couldn’t find anything resembling what I want to achieve in the “recurring” section for automations or when setting up a custom one.
thanks for your reply. So this is a visual of the setup:
So I know how to create a formula that sums up the values entered in the columns for “monday” , “Tuesday” etc. - but I’d like additionally is to add this Sum again to the next column “onboarding”
So let’s say the numbe rin Onboarding is already at 50. If the employee enters 1 for monday, 4 on thursday and 3 for friday, I would like this to be summed up to 8 (which happens via formula) and then add this 8 again to the already existing value of 50 to keep a cumulative value of how much time employees spent on a project overall.
CUrrently this needs to be done manually, and people forget about it or miscalculate so I’d like to automate as much as possible.
Apologies if I’ve misunderstood, however could you input an additional formula column to sum the total from monday-friday columns to the onboarding value?
From what I can understand, a formula column might help here in summing the total values, but will need to be sure of your board structure!
