Sheet Reference Formula Unparseable Error

Tony Fronza

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

Kleerfyre

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

Kleerfyre

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

Tony Fronza

Thanks, @Kleerfyre ! That worked.