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
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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) -
Hi (Hej!)
I'll check and get back to you!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Did you get it working or do you still need help?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives