-
Data Mesh - Not matching some lookup values and not mapping data
Hello, I am using Data Mesh for the first time to move data from multiple source sheets into one target sheet. I've completed my first configuration from one source sheet to the target. I ran the configuration and a lot of the rows in target sheet were updated, but some were not. I've gone back to make sure that the values…
-
Is there an option to add new Metadata to select Existing Projects using the SS Control Center?
When we created some new projects recently, we accidentally missed selecting a metadata (in the profile data) and hence some of our projects are missing this essential information. In order to ensure that all our projects are consistent, I am looking to use the Global Update to add this metadata to these existing projects…
-
Data Shuttle offload how to use the filter function
Hi all, I have a smartsheet with column "Ebene" which contains values like 0, 1, 2, 3 .... How can I filter to offload only values 0? (Ebene=0) has no effect although (Ebene="0") Any idea? Thank you, Joachim
-
Bridge Error
I should start by saying that Bridge is my nemesis.... but I'm determined to conquer it. I'm trying to do a simple workflow, and I keep getting an error with the "Get Row" module The odd thing is.... If I re-copy the sheet ID Data Reference and paste it back in the module, and re-run, it will work.... It might even work a…
-
Smartsheet/Jira Connector - Sprint Complete Date not syncing
Hi, Has anyone encountered issues with the Smartsheet/Jira connector syncing the Sprint Complete Date? When I complete a sprint in Jira, it's hit or miss (mostly miss) updating the smartsheet. However, if I re-initiate the whole workflow, the values do come over. KimR
-
Cloud-based reporting for text reports, NOT data visualization?
I currently use the live data connector and MS Access to report Smartsheet data. Querying, grouping, filtering, sorting… it’s all great. But it requires that I distribute my MS Access front-end to every user and I need to install the connector on their workstation. Is there a cloud-based platform that connects natively to…
-
Data Shuttle Stuck on loading
Hi, Data shuttle is stuck on loading, anyone knows how to solve this?
-
How to Setup Dynamic View - Unable to Get it to Work
I'm trying to setup a dynamic view on projects as some projects are confidential. I have a drop down field setup in the intake form for projects so that we know if the project is "coned". I have tried to follow the steps to hide fields in the intake form sheet if the coned field is yes and the user's name isn't in the…
-
How do I get Data Shuttle to pull information exactly as it's listed in the source file?
I have a column in my source file that includes alphanumeric characters - some characters include an E, which is being translated as an Exponent of 10. Example: 311E9 is being changed to 311000000000. I want the smartsheet to pull the number exactly as it's listed in the source file. Any suggestions? Thank you!
-
How do you create new Programs within Control Centre?
Hopefully a really simple question... I have the PMO Program in Control Centre and that's working well with blueprints etc, however I want to setup another program for Finance and I can't see how or where to do this?
