-
Remove Blank Rows from Dynamic View
Hi SmartSheet Team, Is there a way to remove the blank rows from showing up in a Dynamic View. I thought I could created a shared filtered view that says "Created Date" is not blank and it would just show the rows with dates in them however; this doest work and the blank rows still show up. To be honest, the blank rows…
-
Data Shuttle for Time format
Hello All, I have a question on this data shuttle. Using Data shuttle, I've set column as ETA with users submit times like 02:00. However, when it comes to target sheet from data shuttle, it shows random date data like 1899-12-31. I've change Auto to Text at the data shuttle but unsure how I can make this time going…
-
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,…
