COUNTIFS, ISBLANK, NOT(ISBLANK)

Hi...I want Smartsheet to count a row if it meets three conditions: the "Watchlist" box is checked, there IS data in the "Beacon Submission Done" column and there IS NOT data in the "In PRD column."

Current formula is throwing Invalid Argument Set error:

=COUNTIFS({Watchlist 20230615}, 1, NOT(ISBLANK({B Sub Date})), ISBLANK({PRD})).

What am I missing? Appreciate the help.

Find more posts tagged with

Accepted answers

Carson Penticuff

Give this a try:

=COUNTIFS({Watchlist 20230615}, 1, {B Sub Date}, NOT(ISBLANK(@cell)), {PRD}, ISBLANK(@cell))

Deb W

Thank you, Carson! Did the trick.

All comments

Carson Penticuff

Give this a try:

=COUNTIFS({Watchlist 20230615}, 1, {B Sub Date}, NOT(ISBLANK(@cell)), {PRD}, ISBLANK(@cell))

Deb W

Thank you, Carson! Did the trick.

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.