Pull in totals for Today & Yesterday via a link
We have (1) sheet that is used for basic data entry. No formulas or anything complicated. The user enters the date, start time, end time and categorizes the work they are doing by selecting a single category every task they complete. There are about 7 categories the user can choose from.
In an effort to not disturb the form as users are actively editing, I linked the 7 category types into a separate sheet and created a "countif" formula in a separate column to get the total # of each category.
However, I only want it to count for a single date. And possibly, just have it pull in the count for "today" and "yesterday".