Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 23, 2023 11:19 AM
Hello,
We are running a time study with our teams and we are bringing our data into Airtable from a time tracking tool.
We are running into a scenario where a designer could have multiple time stamp entries for the same task on a project. The problem is we need to be able to sum up like project task records to get the overall total time they spent doing the task, thus creating a new record with the summed time number.
Is there a way Airtable can do this? I started looking at rollups and formulas and I am not too sure where to start or if I am going down the right path.
Thank you!
Solved! Go to Solution.
Feb 24, 2023 12:27 AM
Yeah this is doable. Try:
1. Creating a new table and called it "Summary" or something
2. Create a linked field in your original table to the "Summary" table
3. In your original table, copy the values of the "Name" field and paste them all into the linked field to the "Summary" table
4. In your "Summary" table, create a rollup field on the "Duration" field with the formula `SUM(values)`
You should end up with this:
And here's a link to the base
Feb 25, 2023 08:06 PM
Ah I see what you mean. You'll need to create a formula field that combines the task and project names and use that as the linked field value like so:
I've updated the original base with said functionality
Feb 24, 2023 12:27 AM
Yeah this is doable. Try:
1. Creating a new table and called it "Summary" or something
2. Create a linked field in your original table to the "Summary" table
3. In your original table, copy the values of the "Name" field and paste them all into the linked field to the "Summary" table
4. In your "Summary" table, create a rollup field on the "Duration" field with the formula `SUM(values)`
You should end up with this:
And here's a link to the base
Feb 24, 2023 07:38 AM
Thank you! I will give this a try.
Feb 24, 2023 09:54 AM
Thank you again for providing the example. 👍
I did re-create this base and got everything to work. I did add in one more field on table 1 for the project number. I am wondering if you happen to know of a way that can group the data by specific projects so the rollups are not clumping like tasks from different projects into one.
Here is the base link.
I am not sure if is a super complex build in Airtable that may require a script to be able to separate the data out in that way.
Feb 24, 2023 07:14 PM - edited Feb 24, 2023 07:14 PM
Glad I could help!
The base link you provided doesn't work I'm afraid and I have requested access
Feb 25, 2023 08:06 PM
Ah I see what you mean. You'll need to create a formula field that combines the task and project names and use that as the linked field value like so:
I've updated the original base with said functionality
Feb 27, 2023 09:46 AM
Thank you! This worked for my use case.