I have an excel sheet with at least 4 tabs, and i want to transition that over to Smartsheets
qqqCan anyone assist me in how i can do this, i know smartsheets doesnt include tabs. Below i will give an example.
How can i make this reflect in Smartsheets, and as i get new associates, I would need to match them up to a shift?
I hope that make sense. any assistance would help, thansk in advance.
Answers
-
Hi Genesia,
I do this for clients often. I import each tab into its own sheet and then we talk through the workflow. Usually this discussion leads to new ideas with the Automation Tools within Smartsheet and it almost always leads to a Dashboard to visualize the data. Sometimes 1 or more of the tabs in the excel file are set up like mini dashboards or a series of pivot tables. Once we recreate those with a separate metric sheet/dashboard then we delete the newly imported sheets since they are no longer needed. Maybe give it a shot on your own and if you need assistance, reach back out.
Thanks!
Matt
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives