-
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…
-
Jira Connector: Where did the lightning bolt shortcut go?
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?
-
Sheet output without Column names
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?
-
How to integrate Smartsheet into Google Calendar? How to import Excel info into existing Smartsheet?
Our Construction Company is wanting to have a Smartsheet to keep track of data for our weekly schedules. How do I get our schedule to automatically appear in a Google Calendar? As of right now, nothing is even showing up in our Smartsheet Calendar, so I don't know if it is a problem with the wrong column being made primary…
-
Integrate with Outlook with Dates and Times and Assignee Information
The outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example, when i set a task or appointment date in Smartsheet I would like to be able to…