CountIF issue

=COUNTIF({CBG Cold Spring, MN Items List Range 2}, {CBG Cold Spring, MN Items List Range 1}, >DATE(2024, 1, 1))

Hello i am trying to find non blank in a column based on the criteria that is after 1/1/2024 and this is not working. It says incorrect argument set.

Find more posts tagged with

Formulas

Accepted answers

All comments

Courtney S.

The COUNTIF function for Smartsheet only takes a single range and one criterion, looks like you've got 2 ranges involved in the formula you have written. I recommend looking at the COUNTIF and the COUNTIF function pages to help you re-write your formula:

COUNTIF Function | Smartsheet Learning Center

COUNTIFS Function | Smartsheet Learning Center

jpaul

I agree with @Courtney S. , it would also help to know if you want it to count if BOTH ranges are blank or if only one of them is. Depending on that answer you might also need to look into the AND/OR functions.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.