-
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…
-
From one pipeline to another
Hi there, I have a new business pipeline we use for prospective accounts we are working on. Depending on what happens we either win, lost or are still waiting to hear - these three options are drop down boxes. They are also RGY colour coded. Is there a way to send a line to another sheet (pipeline)? I.e. if we are…
-
Copying hyperlinked cell data and pasting outside of Smartsheet
Hi there, I'm trying to find a way to export hyperlinked words from with a Smartsheet cell to outside programs. Would prefer straight copy + paste. When I directly copy the (hyperlinked) cell and paste into a Word doc, for example, only the text is pasted and not the hyperlink. When I export to PDF or Excel the same thing…
