-
Possible to have a sheet automatically built from another sheet using a formula?
This is probably not possible, but this group is amazing and may have other ideas. I have an ORDER sheet that list various products and services (ITEM DESCRIPTION) into 5 different MARKET(s). This could be 100's or 1,000's of line items with many duplicates. Is it possible to write a formula that would go through each…
-
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 - Export all workflow information as System Administrator
Hi, as a system administrator to conduct audit we need an option to export all the data shuttle information created in our organization. I believe this is must to have because it is hard to sort and get owner email address and so on. Thanks
-
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…