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".
Suggestions?
Answers
-
You could use the COUNTIF() and TODAY() functions to get the sum of the counts per your requirement.
Ryan
-
You are going to want something that looks along the lines of...
=COUNTIFS({Source Sheet Category Column}, "Specific Category or Cell Reference", {Source Sheet Date Column}, @cell = TODAY())
and
=COUNTIFS({Source Sheet Category Column}, "Specific Category or Cell Reference", {Source Sheet Date Column}, @cell = TODAY(-1))
-
Thanks guys -- i keep getting #unparesable -- is that by chance that it needs a place to reference what today is? I tried to put in that reference -- but failed as well.
-
Can you provide a screenshot of the formula in the sheet similar to below?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!