CountIF with multiple Criteria
Answers
-
Hi all,
Im trying to do essentially they same thing here, but it doesn't seem to want to recognize my column names. Any thoughts? When I write the Status:Status piece, it does make them active to that column, but as soon as I get to the Submission Date: Submission date portion, it removes the coloring/linking.
=COUNTIFS(Status:Status, "Assigned", [Submission Date:Submission Date], AND(@cell>DATE (2023, 9, 30), @cell<=DATE(2023, 12, 31)))
-
When a field name has spaces, you need to wrap the field name in the square brackets:
=COUNTIFS(Status:Status, "Assigned", [Submission Date]:[Submission Date], AND(@cell>DATE (2023, 9, 30), @cell<=DATE(2023, 12, 31)))
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!