COUNTIFS with multiple criteria
Hello,
I'm having issues with smarthsheet recognizing my columns 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. I've also tried Submission Date:Submission Date with & w.o brackets.
=COUNTIFS(Status:Status, "Assigned", [Submission Date:Submission Date], AND(@cell>DATE (2023, 9, 30), @cell<=DATE(2023, 12, 31)))
Best Answer
-
Thank you!!
Answers
-
Hi @Btrombler,
[Submission Date:Submission Date] should be written as [Submission Date]:[Submission Date]
Hope this helps,
Dave -
Thank you!!
-
Adding on to this— trying to also include a date range with counting the number of applicants within various depts, in certain date ranges, but it's saying incorrect argument set.
=COUNTIFS(DISTINCT([Name of Requestor]:[Name of Requestor], [Submission Date]:[Submission Date], AND(@cell > DATE (2023, 9, 30), @cell <= DATE(2023, 12, 31))))
Similarly with this, trying to add date range to these, with the second count function being tied to a free text where they write in their department if its not in the original "division"; drop down
=COUNT(DISTINCT(Division:Division)) + COUNT(DISTINCT([Please specify]:[Please specify]))
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!