Mastersheet Linking errors after adding column #unparseable #incorrect argument #blocking

I added a new column to a target sheet. Broke my mastersheet, resulted in #incorrect argument error in all columns with the exception of Primary Column. Went thru checking all column types basic trouble shooting of links couldn't resolve it.

I made a new Mastersheet opened "table view", use formula cell linking. Created 4 separate target sheet links. The Primary column "full name" I received a #unparseable error, and on the other column displays #blocked error.

I then removed my prior column links (in the new Mastersheet) and copied the column link that actually still works in the original Master sheet, still get the same error. #unparseable

This is the cell linking that I copied & pasted, works in original not in new mastersheet.

=INDEX({1 - VOB Range 1}, [Sr #]@row , 1)

At this point I am going to assume the cell linking feature in Table view may work if I can get the Primary column to work? Any help would be fabulous,

Find more posts tagged with

Formulas

Cell linking

Accepted answers

All comments

heyjay

Is the reference name 1 - VOB Range 1 also active in the Mastersheet?

LL425sister

I thought I responded apology if duplicate. The reference name is the source sheet 1-VOB for the first linked sheet in master sheet. Not sure if "active", the primary id is the first column of 1-VOB and Mastersheet for both the original mastersheet and new mastersheet. Original mastersheet link working, all the other columns are not linking ( error above), new mastersheet not linking giving the #unparseable error

LL425sister

I see my responses have gone thru the approval process as a post. My response: 1 - VOB is the source sheet, range 1 was the original formula in the original MasterSheet (and still working), all other columns have error above #. I copied the formula from the original Master Sheet to the new mastersheet and get the #unparsable error. Trying to link primary id's, also tried Table view Formula process and same error.

LL425sister

Yes 1-VOB is the source sheet, range 1 is a range set in original mastersheet. As far as being active in mastersheet, i dont understand the question. Just a note - it is still working in original mastersheet, with inaccurate argument errors for all other coloumns. Does not work in new Mastersheet where showing "inparseable" Any help is apprecicated.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.