-
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.
-
Higher resolution logo options for exporting PDFs
I would like to propose for the ability for Smartsheet to export a higher resolution logo when exporting a PDF. We build key project and production management schedules using Smartsheet that we would like to be able to print and display in A0 size therefore a 300px by 52px logo does not suffice. Furthermore, a logo of this…
-
Printing a dashboard
I have a Dashboard/Portal that I'm using to display reports that (at this time) collectively take about 2-3 screens to page through. This components of the dashboard change many times daily, so we want to be able to take a daily snapshot to maintain as a running status (and send it out by email). However, roughly one-third…
-
Removing special characters
Hello! I am importing from excel and ending up with extra characters in the cell. For example, instead of the cell displaying: Spanish, Portugues I am instead seeing: ["Spanish","Portugues"] Is there a formula that would remove the [ ] " from the cell? Thank you!
