Combining Information from Two Reports
Hi
To make data entry easier, I am using multi-select.
When it comes to reporting this makes the process difficult because I want to create a pivot table to show where the items appear in each individual category. My example below will probably make it easier to understand.
Menu Items are:
- Full English Breakfast
- Soup
- Sandwiches
Using multi-select I show that
- breakfast is available at Breakfast, Lunch, and Dinner.
- soup is available at lunch and dinner
- Sandwiches are available at lunch
The pivot app function has the same issue as exporting the sheet to excel it combines the multi select into a single cell which means that it doesn't allow me to report in a Pivot in either the app or excel.
Unless I create a separate line item for each place where the "full english breakfast" appears on the menu, I cannot achieve what I want.
I know that Smartsheet sheets are flat files for want of a better word because it isn't a database and whilst the multi select has helped with gathering the data, it isn't really great for then doing data work on it. It may be that I am missing something. I have gathered data for a much larger project and I need the ability to split and report on data.
Will have to switch to Airtable as I don't really want to create a single line item for all of the data entered and it would be faster for me to be able to create the reports there.
Has anyone had the same requirement and found a resolution for this?
Thanks
Purnima
Purnima Gore
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
Answers
-
Can you provide a "mocked up" screenshot with sample data manually entered that shows what you are trying to accomplish?
-
Hi
This is the table
This is the pivot report
This is the sheet with the separate line items (as you can see below I now have 16 lines instead of 3)
This is the report I want
I could only achieve this by creating single rows for each combination and then exporting to excel.
I have a feeling that this there isn't an option for this and I will need to use Airtable to do this with three lines.
Thanks
Purnima
Purnima Gore
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
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
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives