Totals for task tracking

[kayleighmaryon]

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.

[TheTimeSavingCo]

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