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?


  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭

    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 multi-select column type for something similar you would have to incorporate the CONTAINS function as well.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!