Count Summary Formula Question

Hello,

Can anyone tell me what formula I would use if I want to count certain criteria based on criteria in another column?

I want to be able to add tiles to my dashboard the number of internal and client meetings based on if the client confirmed.

I have a column for Confirmed by client - Yes/No

I have another column for Meeting Type - Internal/Client

I know I can just count Internal/Client meetings based on one column but I'd rather be able to include all details when I add the meeting to the sheet and not when that meeting is confirmed by client.

What formula would I use in the Sheet summary?

Find more posts tagged with

Formulas

Accepted answers

Peggy Parchert

@BreAnn East -

Something like this?

Formula for Sheet Summary:

Confirmed: Internal

=COUNTIFS([Confirmed by Client]:[Confirmed by Client], "Yes", [Meeting Type]:[Meeting Type], "Internal")

Confirmed: Client

=COUNTIFS([Confirmed by Client]:[Confirmed by Client], "Yes", [Meeting Type]:[Meeting Type], "Client")

Jeff Reisman

https://community.smartsheet.com/discussion/comment/368438#Comment_368438

In this case, you have an extraneous set of parentheses:

All comments

Jeff Reisman

@BreAnn East Let me see if I understand what you're trying to count:

Total Client Meetings that are confirmed

Total Client Meetings confirmed or unconfirmed

Total Internal Meetings that are confirmed

Total Internal Meetings confirmed or unconfirmed

Is that right?

BreAnn East

https://community.smartsheet.com/discussion/comment/368391#Comment_368391

Hi Jeff,

It isn't working. Can you tell me what I need to change in my formula?

=COUNTIFS([Confirmed by Client]:[Confirmed by Client], "Yes", ([Meeting Type]:[Meeting Type], "Internal"))

BreAnn East

I am looking to set up 2 different counts

1 for confirmed client meetings

1 for confirmed internal meetings

both based off of the confirmed with a yes in Confirmed by Client

BreAnn East

@Jeff Reisman

I am looking to set up 2 different counts

1 for confirmed client meetings

1 for confirmed internal meetings

both based off of the confirmed with a yes in Confirmed by Client

Peggy Parchert

@BreAnn East -

Something like this?

Formula for Sheet Summary:

Confirmed: Internal

=COUNTIFS([Confirmed by Client]:[Confirmed by Client], "Yes", [Meeting Type]:[Meeting Type], "Internal")

Confirmed: Client

=COUNTIFS([Confirmed by Client]:[Confirmed by Client], "Yes", [Meeting Type]:[Meeting Type], "Client")

Jeff Reisman

https://community.smartsheet.com/discussion/comment/368438#Comment_368438

In this case, you have an extraneous set of parentheses:

BreAnn East

https://community.smartsheet.com/discussion/comment/368462#Comment_368462

Thank you so much!!! They worked!

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.