-
Trying to understand smartsheet - data integrations
I am a freelance data scientist, and have been given temporary access to smartsheet to evaluate it's capability, and possible opportunities for integrations to support data-heavy work. My standard analytical tools are R and python, both of which have advanced data-processing, analytical, modelling, and visualisation /…
-
Data Shuttle Not Mapping Certain Columns
Hey All, I'm working on a Data shuttle project, and for some reason it's not mapping a couple of columns on the upload workflow. The columns in question are: Block Row Number The offload workflow seems to work fine, as it shows up in the Excel file it creates, but I can't get them to work in an upload work flow.
-
Data shuttle - uploading data from Excel sheet
Hi everyone, I am looking for a workflow, that copies a data from excel file into Smartsheet (which also captures data from the form created within the sheet) without having the team members to access Smartsheet. The reason for considering this upload is, sometimes there will be a bulk data which just need to be copied…
-
Smartsheet and Sharepoint Embed Issue
Quick summary: I am no longer able to view embedded Smartsheet items on some Sharepoint Online sites even though I am the owner of said Smartsheet items and I have Full Control access on Sharepoint. I cannot complete the login (see screenshot) as no login window comes up when I click the button. I am reaching out to my…
-
Disable user's ability to start trials
We just had a licensed user who is not a sys admin start the trial for Data Shuttle. We do not want users trialing things without our approval first. How do we turn that ability off?
-
Automated integrations with Employment Hero, Xero, Artisan Plus.
I would like to be able to import data from several different platforms into Smartsheet and have Smartsheet update some data in a 3rd party platform. There's not much data to shift, so I can't afford an expensive solution, but if it's possible to automate that would be great. Specifically, I want to have our staff and…
-
How will the new email OTP login method impact Live Connector?
How will the new email OTP login method impact Live Connector’s 32-bit ODBC connection?
-
Salesforce Connectgor import Names
Hi! I am using the Connector to import Actions from Saleforce. When I import the fields Action Owner and the Customer Contact, the data is showing like this: <a href="/0053g000001Ter3" target="_blank">John Smith</a>. I just want it to say John Smith. Does anyone have any thoughts?
-
Jira Connector Error: Input collection contains multiple instances of the same element
One of our Jira connector workflows is throwing the error below. What does this mean exactly? "Error code: 1137. Error Message: Input collection contains multiple instances of the same element." Also, the connector is only pulling in 977 of the 994 issues that meet the JQL query. I have looked at the 17 issues that are not…
-
Dynamic View - Data Entry Creates Blank View
I have created a Dynamic View from a Sheet. In the Sheet, I have a filter. When I created the Dynamic View, I added the filter as the view to the Dynamic View (see image). The filter is set to show the next 2 weeks of an external supplier's tasks ("Assigned To" Column). I also included the following columns from my source…