Question
I have two columns on a form that the answer can be a number or a multiple choice answer. Is there a way to create a formula to count how many times the answer of those is not what we want it to be?
Example: The question on the form states "How many minutes was the huddle?" I have it set up to be a numberonly response, and anything over 20 is considered a violation. What kind of formula could I use to count how many over 20 minutes there are?
Answers

you could use a countif formula something like...
=COUNTIF([Huddle Time]:[Huddle Time], >20)
Where "Huddle Time" is the column header for that column in the sheet.
If you are using a multiselect column type for something similar you would have to incorporate the CONTAINS function as well.
Help Article Resources
Categories
Check out the Formula Handbook template!