-
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…
-
Inventory Management (relationship workaround)
Hi, I haven't actually started this in Smartsheet because I don't know where to start. I have an inventory list (excel) that itemizes on multiple rows against one PO#. Like this: Line 1. PO# 12345 Item: Desk Qty 5 Line 2. PO# 12345 Item: Table Qty 4 Line 3. PO# 55555 Item: Chair Qty 3 I am trying to see how I can get that…
-
Bug: CSV import results in wrong column type
When I import a csv file with a numeric column but more than half of the data is 0 or 1's, the column becomes a CheckBox column. Less than half and it is (accurately) a Text/Number column. Either the threshold should be much lower, or any non-Boolean number should force the column type to be Text/Number, or the user…
-
Contact list display/format as email address not name
Hi all, Although I found a thread from 2015 which partly answered my question, I would like to put the it again for updated context and clarity. I have many users in my smartsheet profile and use the contact column type in most of my sheets. I do a lot of list exporting and often need to provide email addresses for a…
-
Import vs Copy and paste
Hello, I currently have a report that gets generated outside of smartsheets, we call this the BOAR report. I previously was copy/pasting the BOAR into a smartsheets grid but sometimes the BOAR is very large and cannot be copied. The reason I was not importing the BOAR is because I have multiple ss reports that are…
