Help with a formula to count how many projects with a brand have the status of "approved"

Hi there,

I'm trying to figure out how I can count the number of projects for a brand have a specific status out of the total projects for that brand. Also, I'm referencing a different sheet for these formulas.

I already have the formula to count how many projects are associated with a specific brand, but now I want to set up a way to keep track of how many of those are approved.

Each line in my sheet is for a different individual project and there are columns for the brand and the status (both using drop downs).

I'd really appreciate any help with this! Thanks in advance😊

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

Lucas Rayala

Hi @mhollar, sounds like you were probably using a cross-sheet "COUNTIF" formula, and you just need to swap to a "COUNTIFS" -- google "countifs smartsheet" to get to the help page for a little reading, but it should be something like this:

=COUNTIFS({Projects}, Project@row, {Status}, "Approved")

I'm assuming that the sheet with the formula has a column with the project names, and I'm calling that column "Project". You can replace that reference with a specific project name. The {Status} just points to the status column, and I've specified that the status must be "Approved".

If this doesn't work, add a screenshot of the source and target page so we can get a better idea of what you're doing.

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.