-
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.
-
Export contacts to Mail Chimp or Google
Can someone guide me to export my Smart Sheet contacts to mail chimp for a campaign? Thank you. Ben
-
Import discussions items
Is there a way to mass import discussion items - I know they can be exported - but can they be imported?
-
Excel Export - Blank Cells No Longer Blank
The recent release has caused an issue with export to Excel. Any empty cell in the Smartsheet isn't actually empty when exported to Excel - I've got a tracking spreadsheet which uses as part of a calculation a count of non-blank cells in a column and this has stopped working. The last Smartsheet export I took on 7th July…
-
Multiple emails for a single "My Smart Sheet Contacts" contact
Hello, As I am entering emails for account (each row) I have an email column which I later plan to output into excel with first and last name and then import into My Smartsheet Contacts, unless someone suggests a better way to do this. Is there a way to have more than 1 email for each contact. Many of my contacts are…
