Contains formula not picking up text



I have this contains formula that searches for M&E and im not sure why its not working.

Could someone please point me to where im going wrong.



Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The problem is with the range portion of the CONTAINS function. Try using "@cell" exactly as I have it.

    =COUNTIFS([Primary Column]1:[Primary Column]5, CONTAINS("M&E", @cell))

    @cell tells the formula to look across the previously specified range and evaluate on a cell by cell basis. When you specify "[Primary Column]1" in that portion, you are telling the CONTAINS function to only look at [Primary Column]1 instead of the entire range already established.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!