Count how many "On Hold" projects for the Sheet Summary

I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold.

COLUMN: Info Still Needed - is a multi select dropdown

COLUMN: Complete - is a check box

I have tried several formulas with no luck. =COUNTIF(complete:complete, 0, Info Still Needed:Info Still Needed, "On Hold") =COUNTIF([complete]:[complete], 0, [Info Still Needed]:[Info Still Needed], "On Hold") =COUNTIF([Info Still Needed]:[Info Still Needed], HAS(@cell, "On Hold"),[complete]:[complete], 0)

am I even close? Are the Formulas in the Sheet Summary a little different that the worksheets themselves?

Based on the screen shot the Sheet Summary should give me a count of "3" for the number of projects on hold, but I would also like to get a quick summary of how many projects I still need the composite rate for"5", or the contract amount"3".

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

Bassam Khalil

Hi @Lula05,

Hope you are fine, please try the following formula:

=IFERROR(COUNTIFS([Notes Info Still Needed]:[Notes Info Still Needed], CONTAINS("On Hold",
@cell), Complete:Complete, @cell = 0), "")

the following screenshot shows the result:

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.