-
Vlookup from Excel to Smartsheet
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple…
-
Import "assigned to" from excel or CSV
I want to import data from CSV or excel where one column is the "Assigned to" contact. Using the user name or email address smartsheet does not recongnise the data imported untill it is manualy selected in the smartsheet cell. This would then be part of a project imported with resource management using teh assigned to…
-
Export row data to Powerpoint or Google Slides
Hey Team, I'm hoping there's a way that I can export row data to a slide presentation (pptx or Slides) similar to the way I can export row data to Google Docs. Anyone have any suggestions? Ideally each row would export to a different slide, and each slide would be in one presentation, but I'd be happy if each slide was…
-
Feature Request - 2 way live data connector
Sure would like to be able to update the status of items in my sheet from the information stored in my companies DBs. I know it's not supported now. Just want to put it out there with my vote for implementation. In my case, we would like an ODBC connection 2-way.
-
Expand Project Row
Hello, I would like to know if you are able to expand a row into a dashboard view. For example, if one row shows a project I am working on, and I have included several notes.. is there a way I can blow it up into a quick view of all items of included in the row (notes, dates, etc.). I would like to show/send the project…
-
Master build schedule to sync with other sheets?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different…
-
Column headers not available to select from Excel import
I have imported many Excel files to Smartsheet. however, I cannot figure out why I cannot select the column headers from my Excel file as the column headers in Smartsheet. I've tried changing thigns in Excel in attempt to support the import: * cell type from "general" to "text * removing filter option * removing and adding…
-
Copy/Paste Not Working Today
Today I copied data from and Excel spreadsheet and tried copying it to corresponding cells in a Smartsheet grid and the paste function didn't work - no data was pasted. I've copied and pasted data into sheets many times in the past and have never encountered this problem until today. Is anyone else having this issue? Can…
-
SUMIFS Cross Sheet Issue
Hello Everyone! I am needing help with the SUMIFS formula for cross sheet reference but when I enter multiple criteria, it returns a value of 0. What I am trying to accomplish is a sum for Sheet-2 based on multiple criteria from Sheet-1: Criteria from Sheet-1 * Job ID* 216116 * Cost Code ID* 7 * 15 * 16 Sum Range: Act.…
-
Data Import in bulk from Excel
Hi, Can anyone suggest how to import the data in bulk from excel, the number of data is around 37000. I can see that we have limit upto 5000, On Smartsheet I have to weekly import the data for the production. Copy and pasting is also not working as we have limit of 500 data at a time.