-
Automating updates from shared Excel doc to a Smartsheet doc
Is there a way to automate updates from a shared Excel file to a Smartsheet doc? I am currently manually entering data from an Excel file into a Smartsheet to update the information on a Sight. It would be great if the data was automatically updated in the Smartsheet when the shared Excel file is updated. Is that possible?…
-
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
-
Can I save over my existing sheet with an imported excel file?
Can I import an excel file and save over in order to capture updates without manually into the smartsheet? We distributing the exported excel version of our sheet to a customer who does not use smartsheet. They return an updated excel file, and we would like to then import their updated excel version to smartsheet and…
-
Importing an Excel document with multiple tabs
What is the best way to import an Excel document with multiple tabs. I tried using the import function, but it only imported the first tab. The formulas have been written in Excel across multiple sheets, and I don't want to lose the formulas. Thank you for any help.
-
Importing csv, google sheet, or excel data directly into an existing sheet.
Why can't you import excel, csv, or google sheet data directly into an existing sheet? Every time it just creates a new sheet, and then I must copy and paste the information into the sheet I wanted to place the data. In Access or other database apps, you can match fields and just import the fields you want directly into a…
-
Importing Google Finance Data into Smartsheet?
Hi all, I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE"…
-
Importing/Syncing Excel File
I have created some sheets that reference a master sheet. This master sheet was populated by importing an excel file. The data in that excel file is generated from a web page that exports to excel and is constantly updating. I'm seeking a solution to be able to update my master sheet. Importing doesn't work as it creates a…
-
Connectivity Issue
Can I import just one sheet from an Excel workbook to Smartsheets without connecting the other sheets in the workbook?
-
Resizing image
When I bring in a .png image to a cell, the image comes in so small as to be unreadable. I can't find a way to resize it. Anybody figured how to resize efficienctly, so we don't have to guess at the dimensions and use the external software program used to create the .png? thanks.
-
Smartsheet connection to teradata
Does anyone know if the live connector will enable me to get Teradata data into smartsheet?
