Help with how to sort data, summary, report, formula?? Not sure

Kris Peeters

I would like to filter, sort, and/or summarize (not sure which option) to see who has check marks in three or less of these columns.

Colleen Patterson

@Kris Peeters

Would recommend doing a helper column with a count if any of those row are checked, then doing the filter off, is less than or equal to 3.

=COUNTIF([Left most column name]@row:[Right most check box column name]@row,1)

This will sum all of the checked fields into a single digit.

Carson Penticuff

One option would be to add a "helper" column. (It could be hidden)

Use: =IF(SUM([Teaching Methods 52]@row:[Reflections on your Instructional Practices]@row) => 3, 1, 0)

Make that a column formula and format as a checkbox. (I'm kind of guessing at that last column name)

You will then be able to add a filter to only display rows where the helper column is checked.

Kris Peeters

@Colleen Patterson it worked! Thank you!

=COUNTIF([Curriculum & Course Design 50]@row:[Data & Evidence Analysis]@row, 1)

Colleen Patterson

@Kris Peeters Glad to be able to help! Feel free to tag me in future requests as well.