Counting Check Boxes Across Multiple Sheets
I have the same sheet for 7 different individuals that has 12 columns and 38 rows...each cell is a check box. I want to create the same sheet that shows a count of each sheet per cell. So, how many of the 7 sheets selected row 1, column 2? How many selected row 1, column 3? And so on.
I have seen numerous discussions about how to count check boxes, which has been very informative, but I haven't seen any that count boxes across sheets. I tried using COUNTIFS and the "Reference Another Sheet" option, but it got very convoluted very quickly. I'm sure I'm doing something wrong by selecting multiple sheets...or maybe I'm not using the right components of the formula between each reference? Any help would be much appreciated!!!
Comments
-
Hi,
I'd recommend using cell-linking to collect everything on the new sheet and then sum everything on that sheet.
Would that work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
I'm not really sure why I would need to do that though. It seems as if there is a formula that could work for me using the ability to reference other sheets, but I think I'm just using the formula wrong. Hopefully someone else has had a need for something like this.
Thanks!
Josh -
Happy to help!
If I understand you correctly, you would need to set up multiple VLOOKUP or INDEX/MATCH formulas so I think it would be much easier to cell-link everything to a master sheet and then do the calculations.
Can you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
LINKS NO LONGER WORK, SO HAVE BEEN REMOVED.
Sure! Here are some published examples (not with actual data or row/column names).
This is the roll-up sheet where I want the formulas to live:
Essentially, I want each cell to show the number boxes checked for that cell from the three sample sheets where they checked the boxes that applied to them.
-
Thanks Josh!
Can you share your email here or mail me and I will share an example Workspace with you?
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree is the BEST! Thank you for all your help in solving my problem. I now have a working document that all of my business users will utilize and gain value. Very much appreciated!
-
Wow! Thanks for the kind words Josh!
It was my pleasure!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!