Question
tmichelle068
✭✭✭✭
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!