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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!