-
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…
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
Pulling data from website into Smartsheet
Hello I am creating a website using Wix and I am embedding a smartsheet form into a page that is only accessible if a user is logged in to the website. Is it possible to pull their name and email into the form automatically? TIA
