How can i create different report sheet with respect to row selection
I have one main sheet where i have different countries' data. I want to create report for each country and just want to lock rows for specific country data. How it is possible to manage it from main sheet to different reports sheets.
Answers
-
Hi @Waqar Ahmad
I hope you're well and safe!
It depends on your sheet's structure, but if it's split by Parent/Children, we could probably use a so-called helper column to identify each row by country and then filter on that in the report(s).
Make sense?
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
Hi Andree,
I saw your response on smart sheet community . Below is my sheet and this sheet have multiple countries' data. I want to create report sheet for each country separately to show relevant country manager to their data, and he should be not able to see other countries' data.
Is it possible to create report file with respect of countries wise, and I just update main sheet, on the other hand different countries sheets automatic update countries wise.
I have tried with filter but if we remove filter all data parents for all.
Looking forward to your support in this regard.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives