Make sub sheets from the main sheet

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

Find more posts tagged with

Comments

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?

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…