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)))

Find more posts tagged with

Countif

Accepted answers

Btrombler

Thank you!!

All comments

DKazatsky2

Hi @Btrombler,

[Submission Date:Submission Date] should be written as [Submission Date]:[Submission Date]

Hope this helps,
Dave

Btrombler

Thank you!!

Btrombler

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]))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.