Why would a formula work on one sheet but be #unparseable on another?

Hello All,

I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable.

This is the formula that works great on my original sheet but is unparseable on my new sheet.

=SUMIFS({Rounding| Number of Staff Contacts}, {Rounding| CPD Educator Name}, Category@row, {Rounding |Date Rounding Occurred}, AND(IFERROR(MONTH(@cell), 0) = 1))

I would also like to add the year in so I can capture the data based on month and year.

Any help would be much appreciated,

Lori

Find more posts tagged with

Healthcare

Formulas

Dashboards

Automations

Accepted answers

KPH

Is the Category column in your new sheet the same column type as the Category column in your old sheet?

All comments

Nick Korna

Hi @Lori C,

You need to define the cross sheet references in each sheet, they're not universal.

As well as that, make sure there is a column named Category on the new sheet, else trying to reference a non-existent column will also cause the unparseable error.

David Ruff

Hi Lori,

It's possible that the sheet references weren't transferred when you setup your new sheet. You can check this quickly by right clicking any cell and selecting "Manage References...". If you don't see your reference names there (e.g. {Rounding| Number of Staff Contacts}), then you'll have to setup those references again in the new sheet.

I hope this was helpful!

Lori C

I added the reference sheets after some playing around, the Category@row is not working for some reason.

KPH

Is the Category column in your new sheet the same column type as the Category column in your old sheet?

Lori C

Hi There,

I just figured this out this morning. I did not have the Category column correct.

Thank you for responding,

Lori

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.