Four tasks, repeated daily, total amount per day

Sorry for the newbie question, if I have the same four tasks repeated daily and I need the totals for those noting respectively, do I need four separate tables to monitor date and total or is there a way to have all four tasks on one table?

The end goal is be able to monitor task totals over week/month.

Hi @Copper

Do I understand correctly that u want to have the totals for tasks completed? Of for information that you add to the created tasks?

I would have a table with the 4 tasks and a table where the daily copies are made via an automation that triggers on the present date via “when record is updated” (formula field with “Today()”) and fills a linked field with the original 4 tasks. Using a conditionally “rollup” or “count”, you could monitor the numbers you need.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.