Skip to main content

I have a “All Completed Tasks” table that holds all of my completed ClickUp tasks - two of the columns are: Project Title and Total Time Tracked.


I have a second “2022 Projects” table that lists all of my projects for the year. I want a field/column in this table to calculate the total time spent on the project, based on the ClickUp tasks from the first table.


I know enough to have a Project Title field in the 2022 Projects table that would match the Project Title field in the All Complete Tasks table (which I think is necessary). But I can’t figure out how to do the calculation.


EXAMPLE

All Completed Tasks table may show:

ABC Project - 12 min

XYZ Project - 9 min

XYZ Project - 7 min

XYZ Project - 4 min

XYZ Project - 9 min

ABC Project - 11 min

ABC Project - 8 min


I would like for 2022 Projects to calculate:

ABC Project - 31 min

XYZ Project - 29 min

Hi Beth,


If you have your Task records linked to your Projects, for example:



Then you can go to your Projects table, and create a Roll-Up field, for example:



And voila you should get the result you are after 🎉



Hope that helps!


Una

Reply


Terms & Conditions