-
Pulling Data from SmartSheet into macro-enabled Excel?
Hello, I am new to SmartSheet and have been working on a project. Currently, the data I am working with is entered through a form by users and inputted from there into a SmartSheet. The data I am working with is free-text text boxes (so things like comments, etc.) and I was tasked with coming up with a way to sort through…
-
Create a "This & Next Week Projects Report" in Smartsheet using RM advanced reporting
Hello, For a while now my teams have been missing a way to see their workload in the coming weeks. Taking screenshots of rm.smartsheet.com or giving them a licence to it are options, but it is either too manual or too costly for my taste. A more realistic alternative was to export reports from RM, reimport the files in…
-
Data Shuttle + Data Table: Move Row Repopulation
I have a large Data Table that gets fueled daily with fresh information. There is a 'KEY' column that uniquely identifies each ROW of data. Using a Data Shuttle, I am fueling a regular sheet with only SOME of the data from the Data Table. Unfortunately I cannot find a way to filter the Table with ANY (and) ALL logic. What…
-
How do I not have data shuttle change Smartsheet data to blank?
I am using data shuttle to update information in smartsheet from an excel csv sheet. There are 6 columns I am having it update. When I run the data shuttle workflow it updates to the new source information including deleting the information in Smartsheet and changing it to a blank value. I have tried to use the filter…
-
Data Shuttle Expressions
I have an Excel sheet and a grid that I am using Data Shuttle to update. My question is: The two columns I care about are Job # and Hours. I was using Job # as the unique identifier in both the Excel and the grid but it is no longer unique in the Excel file, meaning there are now multiple rows with the same Job # but…
-
SmartSheet Data to Excel Macro OR Any Alternatives?
Hello, I am new to SmartSheet and have been working on a project. Currently, the data I am working with is entered through a form by users and inputted from there into a SmartSheet. The data I am working with is free-text text boxes (so things like comments, etc.) and I was tasked with coming up with a way to sort through…
-
Offloading into a csv
I have 2 separate sheets I'm setting up an offloading data shuttle for. I am offloading both sheets with a filter if "x" box is checked. I want to set it up this way so I can use a data shuttle to import both of the csv files onto the same sheet so the columns will map nicely. However, one of my offloading csv files is not…
-
Is it Possible to Automatically Update a Dropdown Based on Booking Counts?
Hi there, I need some input on setting up my workflow and I'm unsure if it's possible. I have a scheduling sign-up sheet where people sign up by date, and each date has a limited number of spots. I want the date option in the drop-down to be removed once the count of bookings for that date reaches "0." Screenshot below for…
-
Merged: Trigger a Data Shuttle Action via Automation Workflow
This discussion has been merged.
-
Share Data Shuttle Workflows
We are fortunate to have multiple Data Shuttle gurus in our organization, but it has become difficult to track who owns the workflows that manage different dropdowns and sheet rows. It would be fantastic if there were ways for all users to easily identify what dropdowns/rows are being updated via Data Shuttle workflows,…