COUNTIF or COUNTSIF
I just cant seem to figure out how to work the formula I am trying to accomplish. Ive googled and watched youtube videos and its not getting me anywhere.
I have a sheet titled "reporting metrics" with three columns. I am trying to pull in data to count the totals from 3 columns from another sheet titled "install file". Two of those columns use checkboxes. I want it to count if the "install complete" column is not checked, AND if "color grouping" column is "blue" AND if "delivered to customer" column IS checked. to let me know the count remaining for each color.
I really hope this makes sense to the help me solve this. I have been trying to figure this out all day😞
Answers
-
It sounds like a COUNTIFS Function will work for you! To look for checkboxes, you'll want to use 0 to indicate "un-checked" and 1 to indicate "checked".
For example, something like this:
=COUNTIFS({Install Complete Column}, 0, {Color Grouping Column}, "Blue", {Delivered to Customer Column}, 1)
If this hasn't helped, it would be useful to see screen captures of your source sheet and the formula you've tried, but please block out sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!