Trouble copying formulas into new sheet

Hello All!

I am having difficulty copying formulas from one sheet to the next- I keep getting "UNPARSEABLE". I have tried copying/pasting in multiple ways, no luck.

Details: Formulas look like =COUNTIFS(Type:Type, "GC", Team:Team, "TM") , "Type" and "Team" being columns in each separate monthly sheet. If the columns are named the same, shouldn't pasting the formulas into the new sheet load the data from that sheet?

Thank you in advance for any advice!

Find more posts tagged with

Formulas

copy

Accepted answers

All comments

Brian_Richardson

Yes copying should work fine. There's probably a subtle difference in the column names, an extra space or something. When you paste the formula you should see the column names turn color…if they are still black then that means it's not finding those columns on the sheet that you're posting to.

Another problem may be that your paste is not including the trailing ) which will also result in UNPARSEABLE

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.