Can I receive data from a client that uses Smartsheets to my own Smartsheet?
I'm looking to automate processes that currently take manual intervention. We're sent an email from the client's Smartsheet system with updates and take action on it. I'd like to get rid of this and have any updates created by them in their Smartsheet sent over to us, is this possible?
Best Answer
-
Absolutely. As long as your system admin allows it in the account settings, you can share your sheets externally, and vice versa. If you share your sheet to a client's licensed admin, and ask them to setup an automation that moves or copies rows to your sheet, it should work just fine.
Editing to add another option - if you're not looking for data to actually move, but rather you want something like a Status update from the client to appear in your sheet, then have them share their sheet to you, then you can setup cross-sheet reference formulas or cell links that will pull the data onto your sheet.
For example, you could have a "Client Status" column with a cell link to the Status column on the client's sheets. When they make updates to their sheet, your sheet will update too.
Answers
-
Absolutely. As long as your system admin allows it in the account settings, you can share your sheets externally, and vice versa. If you share your sheet to a client's licensed admin, and ask them to setup an automation that moves or copies rows to your sheet, it should work just fine.
Editing to add another option - if you're not looking for data to actually move, but rather you want something like a Status update from the client to appear in your sheet, then have them share their sheet to you, then you can setup cross-sheet reference formulas or cell links that will pull the data onto your sheet.
For example, you could have a "Client Status" column with a cell link to the Status column on the client's sheets. When they make updates to their sheet, your sheet will update too.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives