Sheet Reference Formula Unparseable Error

Tony Fronza
Tony Fronza ✭✭✭✭
edited 06/02/23 in Formulas and Functions

I'm using the following formula, which references another sheet to pull in definitions/text:

=IF([Job Family Recommendation]@row = "Accounting Operations", {Job Family Definitions Range 5}), IF([Job Family Recommendation]@row = "Billing", {Job Family Definitions Range 2})

The first leg of the formula works, but when I add the second, I receive a UNPARSEABLE error. I would love to know why this isn't working and if it's possible to have multiple references


Best Answer

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Answer ✓

    Drop the ) after the Job Family Definitions Range 5. You don't need it there when nesting IF statements.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!