-
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…
-
Match or VLookup?
I cannot figure out how to cross reference two excel documents for changes made from one day to the next. Long story short, our EDI process is not working at this time. Until it is up & running, our csr is required to manually review each page for changes from the previous day. It is so time consuming but until EDI is up &…
-
Smartsheet/Google Form Sync
We created a sync between a google form and a smartsheet that records promotion requests. This sheet is used multiple times a day to record these requests. The sheet stopped syncing on August 14 and the team cannot figure out why the sync stopped. We researched the community and help for potential issues. Do you know of…