How do I solve this UNPARSEABLE error for a cross-sheet SUMIFS formula?

Options

I'm attempting to sum a column in another sheet based on matching the product name, the month, and the vendor values in the current sheet but I can't seem to resolve the UNPARSEABLE error. What am I missing?

=SUMIFS({Quantity}, {Product}, Product$1, {Month}, Month$1, {Vendor}, Vendor$1)

Best Answer

  • Monique Odom-Stearn
    Monique Odom-Stearn ✭✭✭✭✭✭
    Answer ✓
    Options

    Hello @Anthony S.,

    I believe you need to put brackets around your column references, so the updated formula would be:

    =SUMIFS({Quantity}, {Product}, [Product]$1, {Month}, [Month]$1, {Vendor}, [Vendor]$1)

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom-Stearn

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!