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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!