Create a report from two sheets but some of the data is the same
I have two sheets that I want to merge into a report but some of the rows are in both sheets as they are either Phase 1 only, Phase 2 only or Both Phases. When they are in both Phases they are in both sheets for many reasons that I will not go into.
Do I need to create 1 further sheet which only has the countries that are in both phases detailed once or is there a way i can bring these into a report from the two sheets?
Thanks
Katrina
Best Answer
-
Thank you Genevieve, this looks a good solution so I am off to try it out.
Katrina
Answers
-
You can set a Filter on your Report to Filter out any rows that say "Both Phases" and that are in Sheet 1. This will keep only the rows from Sheet 2 visible in the Report.
You'll need to set it up with two Filter Groups, one for Sheet 1 and one for Sheet 2, with different conditions in each, like so:
Keep in mind if you're making any edits to those rows, the edits will then only appear in Sheet 2 (the rows showing) and you'll need to open up Sheet 1 to adjust any details there as well.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you Genevieve, this looks a good solution so I am off to try it out.
Katrina
-
This works very well! Thank you again. Off spending time updating all my filters but reports look good now.
Katrina
-
Wonderful! I'm so glad to hear it worked for you. 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives