Count month orders by costumer

Javier ✭✭
edited 06/01/20 in Formulas and Functions


I'm trying to figure out how to count the number of orders on a spreadsheet based on date.

The table has more or less this structure, although with a lot more fields.

What I want it to do is to count on a separate sheet the amount of orders of the current month, what I have planned is something like this:

  • A current date cell with the today formula, so that the value updates daily ->TODAY().
  • A month cell that looks up the month based on the current date cell I mentioned before.


  • A list of the costumers.
  • The number of orders placed on the current month.

The problem is, I've been trying to do it through formulas and the results haven't been what I expected, like this one that ends up counting the amount of days in which the costumer has placed orders.

=COUNTIFS({Dates}; <TODAY(-30); {CostName}; [Costumer Name]1)

Any help will be appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!