-
How to combine multiple sheets with large volume of data
I have a large data set (9K rows + 250 columns) so it is broken up into multiple worksheets. Is there a way to combine? I have figured out how to build reports on multiple sheets, but not how to compile the results for a dashboard (ex: count how many records are across all sheets and have this on dashboard with a breakdown…
-
Imported Hyperlink Text
We have a project management software that generates the above text representing a job location. We import the text to smartsheet though data shuttle so we can distribute dispatch information to our 300 employees. My problem is that the import works as shown above where the URL is incomplete due I'm guessing to the comma…
-
Hyperlinks do not work when sheet is exported
Hyperlinks for sheets do not work, when the sheet is exported to a pdf. However it does work when exported to excel. Any reason for this ?
-
Built in code to sustain Excel project plan hierarchy
When importing Excel project plans into SmartSheet, indentations used for parent/child task relationships need to be maintained. There is a lot of rework otherwise. Thank you!
-
Problem with Data Shuttle that is not accepting xlsx files?
Hi All, Anyone experienced problems with Data Shuttle that it is suddenly not accepting the xlsx files from One Drive anymore? From my side when I open the file itself the section "Protect/Unprotect" sheet under Review is greyed out. Could it be that this is due to Microsoft Information Protection that I'm not able anymore…
-
Error When Importing Google Sheet
I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!
-
Bulk Export through SFTP?
Hi, I need to export a lot of assets in bulk. I would love to do this through SFTP to ensure I am getting the filing and hierarchy correct. I am talking about sometimes 9,000 images at a time and when I do this through Brandfolder's bulk export option I receive an error page and am not able to download anything, I have…
-
PowerBI - How to retain data structure inside of a single column
Hi All Smartsheets has an app inside of PowerBi for automatically importing data where you can simply right click and refresh on the Data panel, as required. This is Brilliant. I am having issues with the following problem: When you 'get data' from PowerBi, you lose your data structure indicated with either a "+" or a "-"…
-
Is an automated export of a Smartsheet to an Excel file possible?
Hi all, I have been having the most frustrating conversation with Smartsheet support on this topic and not getting answers to the question that I asked. I would like to set up an automation that will email me an Excel copy of my project plans on a weekly basis (or when triggered with a change - I don't really care) as I…
-
Is it possible to import a website's calendar?
My company is interested in importing a calendar from one of our website's into Smartsheet. (I would share the link to the calendar page here but the link requires that you login to view that section of the site.) Is there any way to do so? It looks like Google Calendar is the only outside compatible calendar.
