Criterion not being recognized when referencing another sheet.

Options

Hello!

I am trying to count all of the values in a column that contain the letters "CC:". However, every time I complete my formula it returns with 0 as a result. How can I have it recognize this value?

I have posted a screenshot of the sheet I am referencing. Here is the current formula I am trying to use. Any help is appreciated!

=COUNTIF({2024 Documentation & Projects Range 3}, "CC:")

Range 3 is the column I am referencing in the photo.

Thanks


Tags:

Answers

  • Zcollins1995
    Options

    The Task name Column is the Column that is referenced in my Formula.

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    Hi @Zcollins1995

    The formula

    =COUNTIF({2024 Documentation & Projects Range 3}, "CC:")

    Is looking for a cell in your Task Name column that EQUALS "CC:"

    You need to look for a cell that includes the characters "CC:" along with other things.

    Combining a FIND function will do this:

    =COUNTIFS({2024 Documentation & Projects Range 3}, FIND("CC:", @cell) > 0)

    This will also include cells where "CC:" appears in the middle of the string but it is case sensitive and does include the colon so I don't think this will be an issue for you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!