Using Collect with count if and count if NOT

Anna Keeton

I have the following formula I'm trying to run

=COUNT(COLLECT({Target Live Date}, {Checkbox}, "1", {Type}, "Native", {Status}, NOT "Published"))

Count cells with a target live date, where the checkbox is ticked, the type is native, and the status is NOT published.

All seems to be working well until the NOT part. Any clue how to do this?

Thanks all :)

Find more posts tagged with

Formulas

Accepted answers

David Tutwiler

I think you just need to close the "Published" in ( ) and it will work. NOT is a function in Smartsheet so you need to pass it parameters.

=COUNT(COLLECT({Target Live Date}, {Checkbox}, "1", {Type}, "Native", {Status}, NOT("Published")))

All comments

David Tutwiler

I think you just need to close the "Published" in ( ) and it will work. NOT is a function in Smartsheet so you need to pass it parameters.

=COUNT(COLLECT({Target Live Date}, {Checkbox}, "1", {Type}, "Native", {Status}, NOT("Published")))

Anna Keeton

Amazing, thanks David - that sorted it!

David Tutwiler

Awesome! Glad it is working.

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.