combining two smartsheets into one new

marta.jancz

I have access to two Smart sheets that my colleague updates, can I create a joined sheet which I will own but the data will come two the two other sheets?

Adam Murphy

@marta.jancz why not simply use a report? You can add both sheets to a report and add whichever columns you want to see. It allows you to make edits if you have permissions, sort and group the rows, and of course filter results.

marta.jancz

@Adam Murphy thanks, that would work but unfortunately I need them in a sheet to be able to connect it to another data warehouse, which is not possible with the report

Andrée Starå

https://community.smartsheet.com/discussion/137092/combining-two-smartsheets-into-one-new

Hi,

I hope you're well and safe!

Yes, you could use a Report or cross-sheet formulas and connect the two sheets to one another.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!

Adam Murphy

Cross-sheet formulas (Index/collect, etc) and/or Cell-Linking would allow you to have both sheets in one sheet. These will not be editable. Hope this helps.