-
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…
-
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?
-
Smartsheet Revenue & SAP
Hello Smartsheet Community, We are using Smartsheet to forecast revenue. We export recognized revenue monthly and import into SAP for offical reporting. We'd ideally like to be able to set up a connector to eliminate the manual intermediate steps. Is anyone doing something similar in their solution who would be willing to…
-
File Upload to Resource Management - projects
In RM, I need to be able to upload a PDF or Word document to Projects to track SOWs against the project. It would be helpful to be able to load directly to the project.