-
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!
-
Automatically Export Data from a MySQL Database
Hi, I need to automatically import data from a database, which is a MySQL into Smartsheet. My admin tells me that DataIUploader wouldn't work and DataShuttle doesn't have databases as a source option? Does SmartSheet have a tool to automatically pull data from a MySQL database? Thanks in advance.
-
Importing from Excel works one way, but not another?
Hi there, I am trying to create a new sheet from Excel data. If I create the sheet and then go into the sheet and click File>Import>Import from Microsoft Excel, I can pull the data in, but when I leave the sheet, everything is gone. When I import the data, I follow all the usual import steps, but the Save option is grayed…
-
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
