Count of rows created on 2 sheets within a certain time frame.
Hi everyone!
I would like to get the count of rows created on 2 sheets within a certain time frame.
I created a formula (1) to get the count of one sheet and it worked. I tried to add the other sheet to the formula (2) but I got an error message (3).
- =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5, {Created 2}, IFERROR(YEAR2cell), 0) = 2024) = 11
- =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5,{Created 2}, IFERROR(YEAR(@cell), 0) = 2024, {Created}, IFERROR(MONTH(@cell), 0)= 5, {Created}, IFERROR(YEAR(@cell), 0) = 2024)
- #INCORRECT ARGUMENT SET
Can anyone help?
Tags:
Best Answer
-
You would use two separate COUNTIFS (one for each sheet) and then add them together.
Answers
-
You would use two separate COUNTIFS (one for each sheet) and then add them together.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!