-
Saving and exporting
I am a new user of Smartsheet with some questions: 1. Can we save the project plan on a local storage device? 2. When sent as Excel, only tasks, dates, and duration of the task are sent. How can we send the complete view showing the days and weeks on which the tasks are marked? 3. Can we work on the file off line? Thx.
-
Is it possible to keep my original sorting order when pasting in Excel data?
When I paste in Excel data Smartsheet automatically sorts by the first column. Is there a way to prevent this?
-
Calendar Schedule
I'm a new smartsheet user. I'm curious if I'm able to make a sheet, that pulls data from 4 columns and puts the info into Calendar View either to be displayed onto google calendar or on smartsheet calendar. Driver Name: Location: Date: Time: Any help appreciated!
-
Resizing an Image
Is there a way to resize an image that has been inserted into a Dashboard? I am able to increase the size of the Image Widget, but the image is still not large enough and does not fill the widget area. Need to know if I can manually resize the image
-
Export to Microsoft Project Aplying Filters
Hi All, I have been trying to set up a report and later on export to Microsoft project, although without too much sucess. The idea is to show only parents rows (project deliverables). The report is for a client which cannot see the full project plan. Smartsheet seems to always export the full project plan even when filters…
-
Spreadsheet with multiple tabs
I was maintaining an excel spreadsheet with multiple tabs, and some of the fields under these tabs were similar, when i would update this field in master tab, then it would populate the same informatoin on similar fields on rest of the tabs. I imported this excel spreadsheet in to smartsheet and it is importing only first…
-
Question about embedded webform and filtered sheet in confluence
Dear all, I did some research about the following topic but somehow got stucked and every helping hand is appreciated. What is the current status: Currently we are using smartsheet (lets call it "project_overview") to keep track on all our projects. After a few years this list is quite big (around 700 rows) so we are…
-
Connector between Smartsheet and Google Docs
Hello, I need to connect Google Excel (Google Drive) to Smartsheet so that I can have updated data on Smartsheet. I need to know what is the best solution.
-
VLOOKUP Calculation Lag
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call…
-
Schedule an export of a Report
I'm trying to link up a SmartSheet report to our Company wide reporting dashboard in Power BI. To do this I'm looking to schedule an export of a report (say weekly) to save in SharePoint where it is accessed by Power BI. Has anyone else tried this? Is there any way to do this? Thanks! Donna
