You should be able to use the import export menu to
Export a table to a fileThen it will be in Excel.
The use the =COUNTIF(B2:B1776,"yes") function to count up the yes values for each field name.
The you actually have a count by Key word and if you want to get that back into Quick base you could copy paste special and use the "Transpose" option to get a vertical list of field names and their counts, and that can be imported back into a Quick Base table
table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com------------------------------
Original Message:
Sent: 09-11-2019 11:15
From: Adam Keever
Subject: Report of Only Checkbox Fields That Are Checked
Yes
------------------------------
Adam Keever
Original Message:
Sent: 09-11-2019 10:06
From: Mark Shnier (YQC)
Subject: Report of Only Checkbox Fields That Are Checked
So you now have 1,776 fields?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
Original Message:
Sent: 09-11-2019 09:46
From: Adam Keever
Subject: Report of Only Checkbox Fields That Are Checked
To quickly capture opinions on a long list of key words (1,776 words), I imported the words as field titles for checkbox fields.
This allows a user to quickly check words that they agree are key.
My problem is the reporting portion. I want to create a report with only the fields that have been checked and show a summary of the number of checks.
Any suggestions?
------------------------------
Adam Keever
------------------------------