Update Copied Cell

Hello, I have an issue that a report will not rectify.

I have a client facing board, once a cell in each row hits a certain threshold, the row is automatically copied to another board that has different (internal) attributes included. The problem is, there is one cell in each row that needs to continue to update. Right now we are manually linking each cell, but there must be a way to update the entire column one time. As a note, there is a unique identified per row.

Is there any formula I can use?

Thanks!

Find more posts tagged with

Accepted answers

Paul Newcome

Since you have a unique id, you can use an INDEX/MATCH.

=INDEX({Source Sheet Column To Pull From}, MATCH([Unique ID]@row, {Source Sheet Unique ID Column}, 0))

All comments

Paul Newcome

Since you have a unique id, you can use an INDEX/MATCH.

=INDEX({Source Sheet Column To Pull From}, MATCH([Unique ID]@row, {Source Sheet Unique ID Column}, 0))

M Morgan

That worked! Thank you so much!

Paul Newcome

Happy to help.

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.