-
Data Shuttle
I am trying to build our project using the PMO template. We receive a monthly data report that lists all projects and based on a select criterion, those that meet will be accepted as new projects. I want to automatically add those projects to the intake form to create the master template. I've added the data report as a…
-
A way to create a hyperlink for each rows attachment as a column
Hi Smartsheet Team, Is there a way to create a column in a sheet that is the hyperlink/link for the attachment of each row? I am using data shuttle to offload sheet data and the attachments aren't included in the csv file. I thought a link or hyperlink column would be a workaround for this. Any help is appreciated. Thanks…
-
Data Shuttle adding rows not triggering automation
I have an automation set up that when a row a added and [*department* Completion Status] is empty them change [*Department* Completion Status] to "WIP" Does Data Shuttle trigger automations to run? if not is there a way to work around this?
-
NEW: Share Data Shuttle Workflows!
Hi Community, As some good news for your Friday, we’re extremely excited to announce that you can now share workflows in Data Shuttle! With this release, workflow builders and Smartsheet System Administrators can now add users within their plan as workflow managers to Data Shuttle workflows. Meaning no more worries about…
-
Quarterly Planning - Looking to improve collecting team responses
I am in the PMO for a large engineering organization. Currently we have a large portfolio sheet (Control Center Summary sheet) that captures all of the information about each project. In our quarterly planning process, for each project we have the PM input their scope and select which development teams they need support…
-
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…
