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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!