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.

Find more posts tagged with

Sheets

Attachments

Gantt View

Importing and Exporting

Comments

Chris McKay

Hi Orhan,

2. When exporting to Excel, only the cell data is exported and all columns (and formatting) are included by default. I'm assuming you are referring to the ability to export the Gantt chart that appears on the right hand side of your project sheet? If so, this is not possible. You could create an Excel template that does something similar and then copy your data into an underlying tab, but that would require a fairly decent knowledge of Excel.

1. and 3. are somewhat related. There are a number of ways you can work offline, unfortunately none of them are native to Smartsheet and all require some configuration, additional solutions and some trial-and-error:

You can export to an Excel file and work there
You could export to a Google Sheet and then mark the document available for offline access
You could setup a more automated process using an automation product like Zapier and then have Smartsheet update Google Sheets or Excel (if true local storage is required) when changes are made

All of the above will not be 100% perfect for all users and all applications and will need some work to get it close to being a workable solution. I hope this helps.

Kind regards,

Chris McKay

Richard Rymill SBP

Orhan

By integrating Smartsheet with Appsheet, you can store your work locally on any smart device then Sync when you next get a connection, which will save you lots of time and effort trying to save to such as excel, plus you add considerable functionality not available in Smartsheet natively.

If you want to see how this works here is a 2 minute explanatory video link.

http://smarterbusinessprocesses.com/appsheet/

RichardR

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…