Skip to main content
Question

Counting inputs from multiple multiple-choice fields

  • December 8, 2021
  • 0 replies
  • 131 views
MeaganMcOlin
Forum|alt.badge.img+7

Hello,

We have a table with several multiple choice fields. Each multiple choice field is either left blank, is marked "complete", or "incomplete". Somehow me need to count up all the "complete" and "incompletes" in the entire table (not just a single field). I don't know where to start with this? 

Could someone give me some direction?

Thanks!

Meagan 



------------------------------
Meagan McOlin
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • December 10, 2021
Hi Meagan,

In the past when someone is looking for a simple way to count the number of responses across many multiple choice fields is to create two formula numeric fields, one to count the number of fields with "complete" and the number of fields with "incomplete" and then build a formula that checks each field and adds one if it does. Something like:

Sum(
If([Multiple Choice Field 1]="Complete", 1,0),
If([Multiple Choice Field 2]="Complete",1,0),
-Keep adding for each option
)

Then for each record you will have a field you can see the number of completes and then do the same for the incomplete field. Then you would be able to report off those fields and make a summary report or pass that data up in a summary field, etc.

------------------------------
Evan Martinez
------------------------------
    Terms & ConditionsAccessibility statement