-
Help Needed: Creating more efficient ways to update sheets
Hello, I am working on providing dashboards for my seniors. Here is the premise: I have multiple project managers (PMs) that work with four different agencies. Each PM has their own assigned sheet and assign an agency to the project. To create a dynamic dashboard, I am using a separate sheet (a table sheet) that pulls info…
-
Dashboard Widgets PDF Issue
Hi Community, Need some help with exporting Dashboards to PDF. Seem that all the widgets export extremely low resolution. The text seems to be fine, but all widgets regardless of how large or small i make them export low resolution and pixelated. I need to send some dashboards at PDFs and not live URLs so this is a must…
-
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?
