-
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…
-
Use smartsheet data to generate a document that maintains fillable blanks for the recipient
Use: We are using smartsheets to maintain client progress. We have forms that are pdf fillables mapped. We generate these and then email them to the account manager. At that point, the manager still has information to complete ie- other questions on the form that were formatted in acrobat pro to have fillable blanks that…
-
How to load excel dates into DataTable via DataShuttle
Hello, I am trying to load dates from an excel file into DataTable using DataShuttle. The excel file is an attachment on a Smartsheet sheet. DataShuttle is configured to load the date field as a date. I am able to load the date values into DataTable but DataTable does not recognize these values as dates. I also tried the…
-
Fillable PDF boxes are removed when I replace PDF
Hello, Its not that big of an issue but it is very annoying and time consuming. I have a fillable PDF and had all the boxes on the side I dragged and dropped into the PDF and saved it. It works just fine but I had to make some changes and when I went to the same mapping and went to the settings to replace the PDF half of…
