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...
Answers
-
You would use something along the lines of:
=COUNTIFS({Checkbox Column}, @cell = 1, {Tag Column}, @cell = "Property Info")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!