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: 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…
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…
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…
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…
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…
你好,虽然我发现了一个线程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…
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…
There used to be a jira connector shortcut that looked like a lightning bolt on the vertical menu that seems to have disappeared for everyone at my company. Does anyone know how to get this back?
How can I print a sheet without the column names printing? I would also like to be able to export to an excel spreadsheet without the column names appearing in the spreadsheet. How can I do this?
