Need to count how many staff submitted form in last 7 days
=COUNTIFS({Staff name}, ="Kyle Black",({Date Completed}, AND(@cell <= TODAY(), @cell > TODAY(-7))))
or
=COUNTIFS(Staff name:Staff name,"Kyle Black", [Date Completed]:[Date Completed], and(@cell >= TODAY(-7),@cell <=Today()))
One of these i got from customer service and the other i found on a post here. I don't know if i am typing something wrong or what the issue is
Both send back #unparseable
Best Answer
-
AND and the second TODAY should have both been automatically changed to all caps. Double check that your column names are correct in your formula. They must be an exact match to the column names in the sheet to include spacing.
Answers
-
The second formula is missing square brackets around the column names in the first range.
-
-
AND and the second TODAY should have both been automatically changed to all caps. Double check that your column names are correct in your formula. They must be an exact match to the column names in the sheet to include spacing.
-
Ok so i tired an experiment when i separate the argument in to two countif formulas they work. I was just trying to see if there was an issue in the column reference, but when i put them back together in a countifs it goes unparseable.
-
Got it to work Thanks so much i have been so frustrated for the last week!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!