Sign in to join the conversation:
Good morning,
Is there a way to import a whole excel workbook and not just 1 tab?
Hi Kari,
Unfortunately, as far as I know, it's not possible at the moment, it has to be one tab per import, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I'm not aware of a way either. Would be great to have though.
Paul,
Yes, that would be an excellent addition.
Andrée
There are solutions that let you split the Workbook to separate Excel files so that it would be easier to import them to Smartsheet.
Hope that helps!
I've already submitted one a while ago. May just submit another though.
Go for it!
Thank you
Happy to help!
Let me know if you'd want the links!
Hi would you be able to let me know how to split a workbook that would be very helpful
Happy to!
I haven't tested any of these so research thoroughly, and backup before you try them out.
https://www.extendoffice.com/documents/excel/628-excel-split-workbook.html
Please let me know how it goes!
Still looking for documentation, but I am curious about the limitations with the dropdown linking in Table View. Does a person need to have access to the dropdown source sheet in order for the dropdowns to populate on the Table sheet?
I want to add a calendar to my team's dashboard that shows both Anniversaries and Birthdays every year. I have the following columns: Team member Date (date of anniversary and birthday) Anniversary column to show this year's date (formula) Birthday column to show this year's date (formula) When I go into calendar mode, I…
I’m not sure if this has already been asked here or if there’s an existing Enhancement Request, but: is there any way to apply conditional formatting to multiple widgets in a dashboard at once? I have a large number of widgets, and applying conditional formatting individually to each one is very time‑consuming. Ideally,…
