-
Loading SQL Data into Smartsheet
Hello, Is it possible to set up a connection between Smartsheet and SQL Server with automatic updates? For example, if I have a SQL query that updates daily, I want to be able to have a Smartsheet table with the same data that also updates daily alongside the SQL component. Is it possible to accomplish this without the use…
-
Updating Smartsheet from external sources
I have a task list (for want of a better term) that was made in SharePoint and shared with many users. They make updates. I then export to Excel, import to Smartsheet and do what I need to to make an informative report. I can't remove the SharePoint element from this process. I need a way to update some of my information…
-
MS Projects & Smartsheet Import/Export Issues
Hello, I'm having issues exporting and importing plans from MS Projects to Smartsheet's. After doing some Googling, it looks like there's an issue with the successors that MS Projects use. Does anyone know a trick or way around this to make the process easier? We're currently trying to migrate to Smartsheet's from MS…
-
Data Shuttle Not Adding Net New Entries
Hello! I have set up Data Shuttle with the intention that the PM on the project can attach the daily issue log she receives from our IT department and her sheet would be automatically updated. She document she receives from IT is an .xlsx spreadsheet. I noticed that with each new attachment, the existing data would be…
-
Sheet Export to Excel has 1 Blank Row in the middle
Hi there, I'm stumped on this one. I have a basic Sheet with 1944 rows. There are no blank rows. When I do a basic export to excel, one blank row gets inserted at row 1758 of the excel file. The excel file has 1946 rows (1 is blank and 1 is the header) so no info is missing. I can't see anything in the smartsheet rows that…
-
Merged: EU account backup
This discussion has been merged.
-
Predecessors shift by 1 when export to Excel
Rows are numbered starting at 1 in the actual smartsheet view, and when it exports to Excel row number 1 is now the header, which causes the predecessor references to be wrong. I wonder if the fix to this would be to have an actual Row ID column in smartsheet in addition to the row reference? Another option is to prompt in…
-
Is it possible to export only newly added rows in Smartsheet to Excel?
I am working on a group project using Smartsheet. One person's job is to add 70 rows each week. The next person exports the data to an Excel spreadsheet. They want to be able to export only the new rows entered, not the entire dataset. Is there a way to only export certain or newly added rows? Thanks!!
-
Is it possible to export only the newest entries of a Smartsheet to Excel?
I am working on a group project using Smartsheet. One person's job is to add 70 rows each week. The next person exports the data to an Excel spreadsheet. They want to be able to export only the new rows entered, not the entire dataset. Is there a way to only export certain or newly added rows? Thanks!!
-
Data Shuttle - Need to filter new hires within last 30 days
Hi everyone, I'm trying to set up a Data Shuttle offload that will export the following information into OneDrive: Employee Name Role Manager Employee Type Hire Date The problem I'm running into is that I am not seeing any viable way to filter the results within the last 30 days. I setup a report for this as well but…
