-
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?
-
Toolbar Inconsistencies
I have created a "Master Sheet" that I have to import each day and have linked up other tabs/sheet to that Master Sheet to filter out on the information my technicians need to see. On the Master Sheet I have the full options on the toolbar, but on the linked tabs/sheet there are hardly any options. For example, my…
-
Reflecting only Parent Rows (multiple) on Dashboard
For a project release, we're leveraging checkboxes to track completion of validation tasks. I have a dashboard built to reflect progress, however am having trouble finding a way to only choose the multiple Parent Rows/Roll Up data, as it's making me include child data or nothing.. (including all the child row stats will be…
-
Inventory Sheet, moving data to/from Excel and SmartSheet
Hello all, While I have a lot of experience with Excel, I am new to Smartsheet. I've been given a project and I'm having difficulty finding a way to perform what I need in Smartsheet, and am looking for advice/help. Effectively, I have a master inventory list that is kept in Smartsheet of equipment we are configuring and…