-
Connect Power BI to Smartsheet EU Region
Hi, I'm trying to connect from Power BI to data in the Smartsheet EU region. Every solution I find seems to use the default instance, with no way to configure for use with the Europe instance. I've already reviewed the following options: I'm trying to avoid building out some API solution from scratch. Has anyone used a…
-
Collecting Data from Smartsheet Form
I am trying to collect data using a Smartsheet Form. More specifically, I am trying to send the Form to verify that an item has been discontinued with a supplier. I have a column titled ITEM NUMBER, in Smartsheet and will manually add the Item Number, can this number auto populate into the form so my supplier doesn't have…
-
Data Shuttle Workflow - Run on Attachment
I have been trying to figure out for a few weeks now how to set up Data Shuttle to run a workflow based on an attachment. I was sent a video of someone who dropped their Excel sheet into their Smartsheet directly and the workflow ran automatically. I have many sheets for the database that I am building and thus have 2-3…
-
Control Center Deleting Intake Rows
We had 2 items that were created incorrectly in our multi-tier Control Center. We unchecked the created boxes on the intake and deleted them from inside Control Center with the intention of recreating them after applying a fix. We have done this before with other Control Centers when we spin them up as part of the testing…
-
Data Shuttle converting mmm d, yyyy date format to numerical value
Hello Everyone, I have a Data Shuttle workflow that has been run virtually every business day for over a year. When running today, four columns of dates converted to numerical values. No formatting of the source sheet has changed (Excel file with a Custom category of mmm d,yyyy Cell history confirms date format used to be…
-
Is it possible to offload data into data shuttle from a report?
Is it possible to offload data into data shuttle from a report and not just a sheet?
-
Control Center Not Populating Created Projects
I'm just figuring out how Control Center works. I have my templates and blueprints set up. When I create a project manually with the Control Center, the app isn't checking the Project Sheet Created Box column that I selected as the value for created projects. Is there a step I'm missing here? I also can't get the automatic…
-
I have a blank sheet that i want to populate with only the column values from another that contain X
Hello I have a fresh blank sheet, and another data sheet that for example contains the Columns: Fruits, Fruit price/kg, Inventory, etc I want to in my new blank sheet have a Fruit column that only includes the ones with string "apple" so data sheet may contain: Pineapple, green apple, red apple, AND, Orange, Banana,…
-
Data Shuttle issue
This discussion was created from comments split from: Error Message on Offload workflow in Data Shuttle.
-
Task Sheet Global Update
I have updated my "health" column in my task sheet with new formulas and new symbols. I am trying to figure out how to update all my existing projects to have the same symbols and formulas by doing a global update. I chose "find and replace" then my task sheet. What should I enter as my find string?