COUNTIFS

Jason F

Good afternoon all!!

First time poster on here and still learning my Smartsheet.

Stumped on the formula and looking for some assistance.

I'm trying to count the checkboxes in the 2 columns on the sheet below, SUG Scheduled and SUG Completed.

What I am trying to do is count it each column for each similar column for the sheet below, separated by fleet type.

So for example on the second image, I want it to display for 73N SUG Scheduled, that 6 boxes are checked on Sheet1.

Thank y'all in advance!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Give this a try:

=COUNTIFS({SUG Requests Fleet}, @cell = 737, {SUG Scheduled}, @cell = 1)

All comments

Paul Newcome

What is your current formula that is throwing the error?

Jason F

This is the current formula I entered which is giving me an unparse. I still have not been able to integrate to recognize by each fleet.

Genevieve P.

Hi @Jason F

I believe what Paul is asking for is the actual formula copy/pasted that you're trying to use... for example:

=COUNTIFS({Fleet Column Reference}, Fleet@row, {SUG Scheduled Column Reference}, 1)

Cheers,

Genevieve

Jason F

@Genevieve P.

I had forgotten to paste the formula.

=COUNTIF[(SUG Requests Range 3), {SUG Scheduled}:{SUG Scheduled}, =1]

Paul Newcome

Give this a try:

=COUNTIFS({SUG Requests Fleet}, @cell = 737, {SUG Scheduled}, @cell = 1)

Jason F

I got it figured out. It was giving me an invalid ref but I realized I had the sheet references in wrong.

Thank you very much @Paul Newcome

Paul Newcome

Happy to help. 👍️

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.