-
Exporting whole spreadsheet including gantt into excel
Is it possible to export the whole spreadsheet including the gantt chart into excel? When ive tried to export it to excel previously it only gives me the option to export the actions and not the timeline/gantt chart section. Is this possible?
-
Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
-
Exporting to Excel not working with IE
I am trying to export a sheet to excel using IE and selecting Export to Excel. When clicking on that option it there is no indication of any activity and checking the download folder, there are no files there. Could this be a security setting by the company on IE? Could the file be going somewhere else? Thanks!
-
Keyboard Shortcuts (Ctrl+C, Ctrl+V) vs. Right Click Menu Options between Excel and Smartsheet
I've noticed that utilizing keyboard shortcuts (ctrl+c, ctrl+v) provides the needed copy and paste results between Excel and Smartsheet, while using the Right Click mouse method does not. Is there a particular reason for this? Did I miss this instruction somewhere? Thanks.
-
How do I export the names/emails of collaborators who have access to a Workspace?
How do I export the names/emails of collaborators who have access to a Workspace? I need to send an MS outlook email to all collaborators of an existing workspace (over 70 ppl). In an effort to save time (e.g. avoid typing names 1:1) & heartache (e.g. inadvertantly leaving off a person), is there a way to export…
-
Date format inconsistencies, US/UK
If you copy and paste US-format dates (mm/dd/yy) into a Smartsheet while your personal settings are English (UK) (and presumably other Anglophone options), the data will retain the US format for all dates below 13. Where the date is 13 or more, Smartsheet will automatically transpose the format to dd/mm/yy. This can be…
-
Cut and paste rows from Excel without importing an entire sheet
I have created a sheet for registrations and only want to add new registrations from an existing spreadsheet. How do I cut or copy and paste the new rows without importing the entire Excel spreadsheet? I only need to add the new information.
-
Importing into a Project Sheet
Hello everyone, As a project manager/trainer, I have been instructing PMs to create projects schedules using the Project Sheet. This is because it includes not only dependencies, but the timeline option. However, if we want to import from MS Project or Excel using the Import function, it imports into a blank template,…
-
Unable to import a CSV column as Text/Numeric as automates to Drop Down List
I want to create new sheets from CSV or excel data to create a new Smartsheet chart with a project layout and then create a gantt chart. I can achieve all that but the column for Duration insists on creating a "Drop Down List" type which I have to manualy convert to "Text/Number" before turning on the GANTT chart. This is…
-
Printing highlighted changes
Hello! How do I print a sheet that has highlighted changes shown? If I send it directly to the printer or export the sheet the highlights disappear. Does it matter if the sheet is "View Only"? Thanks, Peggy
