Cross-sheet COUNTIF Formula w/in a specific date range
Hi all,
Looking for some help on a formula I have been working on. I am trying to count the number of requests that have been submitted between a specific timeframe (2/14/22-3/18/22). The date column I am looking at is in another sheet (Date OnlyN).
=COUNTIFS({Date OnlyN}, >=DATE(2022, 02, 14), {Date OnlyN}, <=DATE(2022, 03, 18)))
Any help is appreciated. TIA!
Andrea
Best Answer
-
What error are you getting when you try that formula? Error messages help determine what the problem is. Just from the start it looks like you have an extra end parentheses at the end. Make sure your first open parentheses and last end parentheses are the same color.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
What error are you getting when you try that formula? Error messages help determine what the problem is. Just from the start it looks like you have an extra end parentheses at the end. Make sure your first open parentheses and last end parentheses are the same color.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
I was receiving the "UNPARSEABLE" error. I am almost certain that Smartsheet had added that extra parenthesis in at some point. I noticed it was not in color and tried to delete it and it was added back automatically. Not sure why. However, when I tried to remove it after reading your reply - the formula worked!
=COUNTIFS({Date OnlyN}, >=DATE(2022, 02, 14), {Date OnlyN}, <=DATE(2022, 03, 18))
Thank you!
-
@Andrea Mayer Must be that magic I.T. Guy voodoo! Glad it's working now.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!