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 number-only 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?
Help Article Resources
Check out the Formula Handbook template!