countifs issues

=COUNTIFS({Incident Summary Form Range 1}, "Sioux City", {Division}, "utility", {Incident Summary Form Range 8}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 1, 31)))


This worked until i added {Division}, "utility",


can someone tell me what i did

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Kyle Black

    When you say it doesn't work, are you receiving an error or an incorrect result?

    It looks like your other ranges are from the "Incident Summary Form" sheet. You'll want to make sure that when you added in this cross-sheet reference, you selected the right column in the right sheet.


    Then the next thing to check is the type of column. If this is a Text/Number column or single dropdown list column, specifying the criteria directly ("utility") is great, as it will search for what cells match this unique value. However, if the Division column is a multi-select, you may need to add the HAS function around this criteria, like so:

    {Division}, HAS(@cell, "utility"),


    Let me know if any of this has helped!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!