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