COUNTIFS INVALID OPERATION

=COUNTIFS([FirstName]:[FirstName], [FirstName]@row, [LastName]:[LastName], [LastName]@row, [Retailer]:[Retailer], [Retailer]@row, Quarter:Quarter, Quarter@row)

#INVALID OPERATION.

OK, I feel really silly here... why isn't this working?

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hey @BullandKhmer

    Any chance that one of your referenced ranges has an error?

    [FirstName]:[FirstName]

    [LastName]:[LastName]

    [Retailer]:[Retailer]

    or Quarter:Quarter

    If any of these columns have one cell with a formula error, it will bubble up into this overall formula as well.

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!