I can’t seem to figure out how to count the number of occurrences for a given set of criteria.
The original table is taken from a community doc on a habit tracker, but I want to track the number of times in a given week I complete a habit, as I don’t always create habits that I need to complete on a daily basis (some habits are only 2x/week). As you can see from the table, the way this document tracker tracks things is each day it adds the habits into ‘All Habits’ table, and then if I marked the task as complete on another table, it changes the values in the table. I added in the ‘Week Number’ column in order to try and count the number of times I completed each habit in a given week, but have been struggling to figure that out.
I’d love some assistance with understanding how to count the number of occurrences based on multiple criteria. My plan is to put the number of times I complete something each week in ‘Weekly Completed’, and would like for this to reset every Monday. I have the current week number set up such that the week number will automatically update for me, as seen above the first table. Thank you