Pull in only Mondays and count rows for that week

Options

I have a grid with Order data, one order per row. Each order has an order date.

In the Orders grid Sheet Summary, I have the following formula for Weekly Total to capture the last full week of data: =COUNTIF(Date:Date, AND((IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()) - 1)))


In a separate grid or report, there are two columns of data I have having trouble with formulas for:

1) Date: I want to pull in the distinct Date from the Order grid, but only for Mondays. Is this a VLOOKUP with WEEKNUMBER or is there another way?

2) Weekly Total: For each Monday, I would like to count the number of orders (number of rows) for that week (Monday - Saturday).

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!