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.
Page 1 / 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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.