Data containing parenthesis

Matt Galindo
Matt Galindo ✭✭✭✭
edited 03/10/23 in Formulas and Functions

Hi,

I have data that contains a parenthesis. Is there a special way to reference data that contains a parenthesis in countifs statement? Here is the formula:

=COUNTIFS(Category:Category, "System Maintenance (Post Go-Live)", Rating:Rating, "1")

Any suggestions?

Thanks,

Matt

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 03/10/23

    Hi @Matt Galindo

    As long as it's wrapped in quotes the formula should have no problem with that value:

    Are you seeing incorrect results or an error? If so, could you post screen captures of your current sheet set-up, but please block out sensitive data.

    Cheers,

    Genevieve

  • Matt Galindo
    Matt Galindo ✭✭✭✭

    Hi,

    The formula you posted looks like mine. The data in the Category matches exactly. I am not getting an error message, just an incorrect result. You have the same situation I have with the "(" being highlighted - being interpreted as part of a formula. I have multiple values in Category, but this is the only value that contains parenthesis. All other formulas related to the other values in Categories are calculating correctly.

    I've attached a screen print of data. Here is the formula:

    =COUNTIFS(Category:Category, "System Maintenance (Post Go-Live)", Rating:Rating, "4")

    Thanks

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Matt Galindo

    Thank you for the screen capture! Even though the parentheses highlight, they should still be seen as text because we've wrapped it in quotes.

    Can I check to see if this incorrect result is related to how you have the Rating column value displayed? I see you have the number 4 wrapped in quotes in your formula, which would cause the formula to search for a text string of 4, but it looks like your sheet has the Rating column set as numerical values.

    Do you get the correct result with the following:

    =COUNTIFS(Category:Category, "System Maintenance (Post Go-Live)", Rating:Rating, 4)

    Could you maybe try filtering the sheet by your two criteria to double check what the outcome should be?

  • Matt Galindo
    Matt Galindo ✭✭✭✭

    Thank you Genevieve.

    Removing the "" around the values worked.

    Matt

  • Genevieve P.
    Genevieve P. Employee Admin

    Great! I'm glad we could figure it out 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!