Sheet links does not update automatically

Hi,

I have one column of a sheet linked to one master sheet using Cell Linking.

Just to add on to the information, the linked column in the master sheet is auto numbered and creates a unique ID of each row. The other columns in the linked sheet fetches the row information from the master sheet based on the INDEX(MATCH) formula. The auto number generates whenever a form linked to the master sheet is filled up by any form user.

Now the challenge I am facing is that the Cell Links does not get updated automatically whenever the Master sheet get the new auto number or ID. Can anyone help on why it is happening?

Prajna

Find more posts tagged with

Accepted answers

All comments

Ramzi K

@Prajna Jain

INDEX(MATCH) references a row number not an auto number in a row. So if you are pointing your formula at at autogenerated column it may not work.

Can you please include some screenshots if you need additional assistance?

Cheers,

Ramzi

Mindfull

@Ramzi K

Thanks for the reply but i have issue with the sheet linking...the formula related information is just to add on to how my sheet are structured.

Ramzi K

@Prajna Jain

Perhaps screen shots would be helpful in this case.

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.