-
Automating a Gantt chart from Jira Kanban in early planning
The execs want a Gantt chart from my Kanban board. I will be using the Jira/SmartSheet connector for this task. Here is my current thinking: * Take the total number of tasks and divide by the available work time to create an average size if the tasks completely fill the time (the SME who will be sizing the items has not…
-
Saving smartsheet in Google Drive
I can't seem to figure out how to save my Smartsheets directly into Google Drive. I have the Smartsheet Google app, and when I'm within Google Drive, it will allow me to create new Smartsheets directly from Google Drive, and then they appear in my Drive and shared folders. However, our team already has several Smartsheets…
-
Exporting Excel formulas
I noticed that formulas, even simple formulas are not exported to a Excel. I have a big smartsheet where we created butcket that has additions per row (summarized) and we noticed that they're not exported as formulas in Excel. It's a shame because we have to start over in Excel an create template and data again. Is there…
-
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…
