Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Totals for task tracking

Topic Labels: Formulas
209 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kayleighmaryon
4 - Data Explorer
4 - Data Explorer

I'm building a task tracking app within airtable to use with Glide. I would like to do a rollup of total hours spent on each task bucket (four in total) for the current month, week and day. I cannot figure out how to do a sum of each task for those time frames as a numeric value and hours spent on each task. Any help appreciated.

1 Reply 1

You're going to need a table where each record represents a single task bucket and a single period you want to track, e.g.:
Task Type 1 - Day 1
Task Type 1 - Day 2
Task Type 1 - Week 1
Task Type 1 - Month 1
Task Type 2 - Day 2
etc etc

And you could automate this by using a formula field to create a unique text value per task bucket <> period combo, and pasting that formula field into a linked field every time you log the hours.  In the screenshots below, the "Text to Paste" field outputs "Week - 08 24 - Task 1,Month - 35 24 - Task 1,Day - 26 08 24 - Task 1", and when that's pasted into the linked field it creates 3 records

Screenshot 2024-09-07 at 9.50.46 AM.png

Screenshot 2024-09-07 at 9.50.43 AM.png