Pull in only Mondays and count rows for that week
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
-
Are you able to provide a screenshot for reference?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Here is a snip of the orders table.
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 (count of rows) for that week (Monday - Saturday).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!