Time Study Data Scenario - Combine like records into 1 that can sum time spent
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!
Accepted Solutions
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
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
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
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
