Report columns from 2 sheets to appear side by side
I have a report that pulls several columns from two sheets. By default, the rows from 2nd sheet appear below the rows from 1st sheet. But I want the rows from 2nd sheet to appear to the right of the rows from the first sheet. Is this doable in Smartsheet?
And, what if the number of columns I need both the sheets are not same? In other words, what if I want 5 columns from first sheet and 8 columns from the 2nd sheet?
Best Answer
-
Hello @pd_njit,
You cannot combine multiple rows into one single row in a report.
Additionally, if you have different columns in Sheet 1 vs Sheet 2 then for a row in Sheet 1, the unique Sheet 2 columns will be blank and vice versa.
You could consider reversing this strategy - use one Sheet with all of your columns and then make reports that separate columns for what you currently have as Sheet 1 and Sheet 2.
If you need to manage them in separate Sheets than you could use lookup formulas or DataMesh to get the data all in one row in either Sheet. This would entail:
- Having a unique identifier that is consistent in both Sheets (a lookup value),
- Adding all of Sheet 1 columns to Sheet 2 (or vice versa),
- Using lookup formulas or DataMesh to get the data from Sheet 2 to Sheet 1 (or vice versa),
- Hiding the lookup columns,
- Building a report off Sheet 1.
Hope this helps!
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Answers
-
Hello @pd_njit,
You cannot combine multiple rows into one single row in a report.
Additionally, if you have different columns in Sheet 1 vs Sheet 2 then for a row in Sheet 1, the unique Sheet 2 columns will be blank and vice versa.
You could consider reversing this strategy - use one Sheet with all of your columns and then make reports that separate columns for what you currently have as Sheet 1 and Sheet 2.
If you need to manage them in separate Sheets than you could use lookup formulas or DataMesh to get the data all in one row in either Sheet. This would entail:
- Having a unique identifier that is consistent in both Sheets (a lookup value),
- Adding all of Sheet 1 columns to Sheet 2 (or vice versa),
- Using lookup formulas or DataMesh to get the data from Sheet 2 to Sheet 1 (or vice versa),
- Hiding the lookup columns,
- Building a report off Sheet 1.
Hope this helps!
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Thank you, @Dan Palenchar. It is insightful. Let me try out the options.
-
Happy to help @pd_njit! Have fun trying them out :)
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 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
- 302 Events
- 33 Webinars
- 7.3K Forum Archives