Formula that will look at how many submissions there have been by group in the last 7 days
I am trying to figure out how to pull the data from a different sheet to build my roll up and dashboard. I am trying to use the following formula. The goal is to be able to show how many submissions there were last week for each group.
=COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY()), ({JHA Tracker with Form Range 66}, @cell > TODAY(-7)), ({JHA Tracker with Form Range 4}, (CONTAINS("I&R", @cell)))
Best Answer
-
You are doing too much with the parenthesis. Try this:
=COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY(), {JHA Tracker with Form Range 66}, @cell > TODAY(-7), {JHA Tracker with Form Range 4}, CONTAINS("I&R", @cell))
Answers
-
You are doing too much with the parenthesis. Try this:
=COUNTIFS({JHA Tracker with Form Range 66}, @cell <=TODAY(), {JHA Tracker with Form Range 66}, @cell > TODAY(-7), {JHA Tracker with Form Range 4}, CONTAINS("I&R", @cell))
-
It got me closer I think, gave me an Incorrect Argument error
-
Just refreshed and it worked. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 506 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
