Countif Contains. Trying to sum "No" but picking up "Not" into account.

Countif Contains. Trying to sum "No" but picking up "Not" into account. 

What should I change in order to pick "No" only.


Thank you

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Renat

    Could you post screen captures of your current sheet with example data? I'd like to see what types of columns you're using.

    If you're evaluating multi-select fields, you can use the HAS Function instead of Contains. That will look for an exact match.

    Try:

    =COUNTIF([1. Select Date]@row:[Person Completing the Form]@row, HAS(@cell, "No"))

    Cheers,

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!