-
Setting up Automatic Provisioning for users
I'm setting up automatic provisioning for users with AD and at the portion where it is asking for my API Key and Tenant URL. I have the Key, but I'm wondering where I can find the Tenant URL? Is there one specific to our Tenant or is there a generic URL?
-
Reports - not identifying the columns correctly
Hi Everyone, We pull the sales figures out of the finance system then upload to Smartsheet, with effect that the Column names are exactly the same, however when we create a report with 2 sheets ( March & April) it brings the column names in twice, for instance I select the 2 sheets, then on the columns it will say "QTY"…
-
Tracking duration of markets engagement
Hello, I am working on a tracker for my team. Each member is responsible for managing tasks for a different area for different markets. We want to track how much time each market has spent for each task per months/quarter/year for each area managed by our team. It would be perfect to pull report from the main sheet but I…
-
Tracking Production Build
I was wondering if anyone has a template for tracking manufacturing build plan. For example I have a device that requires 11 different sub-assemblies before a finished product can be completed. To have a continuous build of 20 finished units per months I need to have at least 5 of each sub-assemblies built per week. What…
-
Smartsheet to Excel via Power Query
Hello, I have ran into an issue where parts numbers get recognized as null by Power Query if the column type is text. When exporting the Smartsheet there are no issues what so ever but depending on the length and contents of the part number it will get dropped. Please refer to the below image.
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Display All unique Level 1 Hierarchy from one smartsheet to another
Hi I have equipment as a column in EQ needs smartsheet and it is a level 1 when expanded I have all the data below it for that piece of equipment. I am trying to make a calculations sheet that will only show all the types of equipment (level 1) entered onto the calculations sheet. When I go to the calculation sheet it will…
-
Data Shuttle Keep Data in unmapped column
We are using data shuttle to upload from a csv file once a week on Mondays. Throughout the week we have an assigned to column (that is not in the data source file) where people assign themselves to tasks (so different rows in the source file). They might not get to the task that week, so when we update the the data on…
-
3rd Party Connector: "Your Access Token has expired."
Our company uses a few 3rd party connectors to push updates from Smartsheets to other systems. Periodically, all our connections will go into meltdown (we will end up using 40,000+ connection steps in less than 2 hours - normally about 10,000 per month) because Smartsheets is responding with "Your Access Token has…
-
Docusign Formatting - Box/Border around imported text fields
I'm pulling info from Smartsheet into my Docusign PDF template and can't get rid of the box that Docusign puts around text. I'm trying to pull Smartsheet info into a table in the PDF so I'm ending up with a box within a box. Is there any way to get rid of the box/border Docusign wants to put around text fields?