-
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
-
Multiple Sheets - SUM Dollar Totals in Report
I did a quick search in the community and didn't see this answered exactly, but i think either an Excel export or a future release of Dashboards may provide a quicker/better solution. So here's what I'm trying to solve. I've got 10 sheets that track Paid Claims. When the Claim is paid, a field titled "Date Payment Received…
-
Send sheets to another licensed user
I have sheets that I want to send to other licensed users which they can then "own" and modify as they need for their particular situation. I don't want to Share or Collaborate, just send and forget. These sheets would be part of a suite including live links between sheets for rollup reporting that have to remain intact.…
-
Smartsheet in Powerpoint - Not Gantt Timeline
I want to either export or copy and paste my Smartsheet into a Powerpoint table once a week. The text has to be editable after I paste it. When I copy and paste, it loses all formatting. The transfer process is going to be used by my director, and I can't ask him to do a lot of transformations or steps to reach the…
-
Enhancement Request: Choosing which task to display on Agenda
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…