-
Data Shuttle Error
Hello, I'm just uploaded a new excel doc and am trying to run Data Shuttle so the information on my sheet will update but it doesn't appear to be working. After it finished running, I checked and it said no rows were updated so I was checking the workflow and keep receiving this error: I've checked my rows and everything…
-
Can we create multiple dynamic views from the same sheet?
I have a sheet in Smartsheet that want to create 2 different views that one dynamic view is restricted by the PM column and the other dynamic view is restricted by the Incident Advisor column. I was able to create one dynamic view, and when I duplicate the same dynamic view and rename it and change the restrict by, the…
-
Can you use data shuttle to migrate smartsheets from one server to another?
Our organisation has been merged with another, and we need to migrate a huge raft of existing live smartsheet project plan data, reports and dashboards from US servers over to smartsheet on UK servers. A number of us have licences for both versions to enable the migration, but we need to complete in the next 3 months. We…
-
Reverse Geocoding
I am using a form with the pin drop to track sales employees in person visits / cold calls. The return value in my data sheet is the location coordinates hyperlink that takes you to Google Maps. Is there a way I can extract the address information from the coordinates into a separate column on my sheet? I have an…
-
Knowledge Base to Onboarding
I am setting out on a path to utilize Smartsheet as a Knowledge Base platform for our department. Just as the brain is made up of many parts and connective tissue, so are the functional roles of the business. Smartsheet does integrate video, SharePoint and Lucidchart which conveniently reduces Phase 1 setup. Phase 1 -…
-
Update SMARTSHEET using Power Automate
Hello, I have an updated Excel file, and I would like to transfer new rows of data using Power Automate. I see the ability to go from SMARTSHEET to Excel, is there a way to go from Excel to SMARTSHEET? Thanks, Shahara
-
How to combine cell change notification and Data Shuttle
Hello Community, does anyone has an idea to solve the following problem? I have a data shuttle running every night, pulling information from an excel spreadsheet into a sheet (let's call it sheet 1). Do to the fact that there is no unique identifier in that Excel sheet, Data Shuttle completely replaces all the entries in…
-
SmartSheet Jira Connector
Hi Team, We are trying to integrate SmartSheet into Jira, however when looking at "Jira Connector by Smartsheet" I see the following: https://marketplace.atlassian.com/apps/1215530/jira-connector-by-smartsheet/version-history We are running Jira Cloud. "version":"1001.0.0-SNAPSHOT", "versionNumbers":[1001,0,0],…
-
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
-
Document Generation/Dynamic Views & Conditional Formatting
How can I set up a generated PDF document to carry over the conditional formatting from my grid? Can the Dynamic View also show the conditional formatting applied to the grid? This works for reports but I haven't been able to figure out how to set the document or view up to show the conditional formatting in the grid...…
