Counting help

Hi There! I am trying to create a reference sheet to pull data for a dashboard and am trying to figure out how to count instances a item with a certain value is check off. So, how many items checked off of the list are for "Property Info". I've tried using COUNTIF, COUNTIFS, COUNTM and so on, but I can't seem to figure this one out...

Is there a way to tell the formula "If an item is checked off and is tagged as 'Property Info' count it here"

I want to be able to show a quick snap shot of how much information has been received and how much is outstanding.

I did add hierarchies to maybe help keep the data accurate if lines are added...

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would use something along the lines of:

=COUNTIFS({Checkbox Column}, @cell = 1, {Tag Column}, @cell = "Property Info")

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.