Multi sheet sync

Greetings

I have a main sheet consisting of columns 1,2,3,4,5

I have sub sheets with the same columns where column 5 is unique to each sub sheet

IF I add a row to the main sheet I want it to appear in the sub sheet listed in column 5

IF I add a row to a sub sheet I want it to appear in the main sheet with column 5 properly designating which sub sheet it came from.

I used a simple workflow for sub to main but if I use the same workflow in the main sheet seems like a loop would be created and both sheets would get filled up .

Any help or ideas are appreciated.

Thanks

Tim

Find more posts tagged with

Accepted answers

All comments

Adam Murphy

I think your simple workflow is what I would have suggested, with the addition of helper columns to indicate source sheet (which can then be used as a filter on the reverse workflow). Would that work to stop the infinite loop you're describing?

Tsbullard

That is what I am trying now. Thanks

Simpler is better

Tsbullard

I would like the helper column to automatically get the sheet created in name.

OR maybe I can give each sheet a code that Auto generates on row creation. HMMMM

Will post here if I find the answer

HAve FUn

Tim

Tsbullard

Greetings

I have the copy rows from Main sheet to sub sheets and vice versa working without causing a loop using a column that contains the name of the sheet where created with an index number(prefix is name of sheet and number is generated when row created)

I would like to be able to edit a row in either the main sheet or the sub sheet and use an UPDATE function to the row in the other sheet . In SQL it would be update column xyz where column a in other sheet matches column A in this sheet.

Seem like this should be doable.

Thanks

Tim

Tsbullard

Well this got complicated fast

So hopefully this will clarify what I am Trying to do

Main sheet has all rows in it

Sub sheets have a subset of the rows in them designated by a cell in the main sheet.

IF a row is added either to the main sheet or the sub sheet copy to the other.

IF a row is edited in the main sheet or the sub sheet update the other.

Sounds easy

Any ideas out there

If I find a working solution I will post here.

Thanks

Tim

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.