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
Answers
-
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?
-
That is what I am trying now. Thanks
Simpler is better
-
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
-
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
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!