Make sub sheets from the main sheet

pixy995

Hi guys,I have the main sheet with a lot of data (rows and columns). I want to make sub sheets, which should include all rows from the main sheet, but not all columns. I also want to have functionality if I change something in sub sheet, I want it to be updated in the main sheet... Also to work in the opposite direction - if I change something in the main sheet I want it to be updated in sub sheets.

I know I can use Reports for this, but I don't want to, because there is not hierarchy in Reports. 

Does anyone have an idea how can do it? Actually, is it possible?

Thank you

Andrée Starå

Hi,

Interesting!

What's your use case! How would you use it?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

pixy995

Ok, let's try.



Let's say that this is my main sheet (first screenshot). And for example, I have 2 employees. One of them should fill columns 'Properties' and 'Property Value', and the second employee should fill columns 'Manufacturer' and 'Product'. I want the first employee to have approach to the sheet which should look like second screenshot and second employee to have approach to sheet which should look like the third screenshot. 

Also, I want this to happen: if some of them make changes in those two sub sheets (fill some cells, or change value in some cells), I want it to update appropriate cells in main sheet. 



And if I make any change in main sheet, I want them to see that change in their sub sheets. 



I know I can use Reports for that. But I am looking for other solutions. Because if I use Report I lose hierarchy which is very important. (I have a lot of rows. And if I lose hierarchy I can't minimize children rows)  

Andrée Starå

Hi (Hej!) 

I'll check and get back to you!

Andrée Starå

It seems like you would want two-way communication and that's unfortunately, not possible. That's an excellent idea though!

Please submit an Enhancement Request when you have a moment.

There might be some workaround possibilities, but I would need to understand the process better to be able to give a better recommendation.

Do you want all fields to be "synced" or is it specific columns?

Andrée Starå

Did you get it working or do you still need help?