-
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…
-
Imported Contacts not 'syncing'
I imported an excel spreadsheet that has a column of names. The column was imported as text. I changed the column property to Contact list. As I add people to my account contacts, the rest of the cells in that column with the same name are not sync'ing (?). Smartsheet wants me to add another contact entry. Is there a way…
-
Importing an Excel file problems
I have an Excel xlsx file with multiple worksheets. I first worksheet is the one I am trying to import. and it has only 28 columns and 125 rows. None of my worksheets have more than 28 columns ofr data or formulas. When I attemp to import into SmartSheet tells me: "the file you are imports has a worksheet with more than…
-
cost and efficiency trend calculator
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
-
Copy/Paste outside of smart sheets
I often need to copy and paste from and to smart sheets, but find that it uses its own clipboard. Say I have a 9 digit number in an excel sheet, and I want to just bring the info from that one cell into my smart sheet, I will copy from excel, but when I paste in smart sheet, it pastes the last info I had copyied within…
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
Importing Excel Headers Blank
Hi everyone. When I import an Excel file the headers are blank (white) until I scoll over them. When I do they appear as long as I hover over the cell. When I move away they turn back "white" or blank. Any idea on how to prevent this or change the properties so they will always show up.
