Can we copy data automatically based on some condition from a sheet to excel in sharepoint
Can we copy data automatically based on some condition from a sheet to excel in sharepoint ?
Answers
-
Hey @Ravi Sagar
If you have access to the premier app DataShuttle, you may be able to use offload data from smartsheet to sharepoint excel. DataShuttle will run on a schedule (not a trigger). The data exported can be filtered to meet conditions. If this option is available to you, it will be very straight forward to set up and the community is available to answer any questions. If available, try this first.
A different approach is to use power automate. This will be through your Microsoft Office account. https://powerautomate.microsoft.com/en-us/templates/details/70e1ab21ef954033ada4704d38fec6e6/copy-data-from-smartsheet-to-excel-online-business-spreadsheet/
Will either of these work for you?
Kelly
-
I recently did this. I have an excel sheet that automatically connects and pull data from a smartsheet. If this is what you need message me.
-
Minoguejj,
Please explain how you were able to set up the automation to pull data from a smartsheet to excel.
Thanks!
Julie
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives