Solved: Summarize values selected from an enum list (essen... - Page 2

kmelendez128 · 07-03-2024 06:03 PM

I'm new to appsheets and am trying to figure out how I can count values selected off a enumlist.

I am using the forms view; the form will be used to capture and collect assessment data.

I have five different questions that are enumlists. Each question has between 3-5 answers/values that can be selected. I want to be able to count all of the values/answers that are selected out of the total values available. Ideally, I would like to be able to pull out the percentage of all values selected out of all available values (for example, a total of 20 out of 31 values available were selected accross the five questions, which accounts for a 64% performance based on the assessment). Taking it a step further, I would like to be able to pull a list of the values that weren't selected and what associated question they were a part of.

Any help is appreciated. Thank you!

AleksiAlkio

Because the EnumList generates a list, you can use for example SUM([EnumList]) or COUNT([EnumList]). Then you can combine them like COUNT([EnumList1])+COUNT([EnumList])+..etc.

The percentage can be like.. 1.0*(COUNT([EnumList1])+COUNT([EnumList2])+..)/31

The last request.. LIST("Option1","Option2",..,"Optione31")-[EnumList1]-[EnumList2]-..etc. should give you the list of not used options.

View solution in original post

Summarize values selected from an enum list (essentially countif selected / totalcount)