-
Clear a sheet using Bridge
Hi all, I have developed a Clear Sheet solution using Bridge. Using Bridge allows you to incorporate a sheet clear into a Bridge workflow, rather than trying to align timing between workflows and other sheet clearing methods like automations and Data Shuttle. Once setup, you simply call this Clear Sheet workflow using the…
-
Multi-tier reporting in Control Center?
I am looking for a way to set up a report in my parent blueprint so that: Every time a new child project is provisioned, a specific sheet from that project is added to the report at the parent level. The parent report is a collection of that sheet in all child projects. Things I tried that didn't work: -Adding the child…
-
JIra-Smartsheet Connector
Hello All Just trying to figure out it if it is possible to create a Smart sheet workflow from Jira Cloud to smart sheet and within the workflow only connect it to a single ticket or Epic. We do not want it to pull the data in from the entire project. It is a Jira Work Management. Trying to figure out if there is an option…
-
Data Shuttle changing the format of imported rows
I am data shuttling an excel spreadsheet .xlsx when adding any new data it is changing the format of the field. The entry in the field should look like 2019 when new data is shuttled over it changes this to 2019.00. The format of the rows in the excel are number and no decimal places. Does anyone have any ideas
-
Data Shuttle not updating blank values from source file?
Anyone else having this issue? All the Data Shuttles that I set up, are not anymore been bringing data to Smartsheet from cells that have changed to being blank in my Source Location. This was discovered yesterday, 10/17, when I received many reports from colleagues that work on different sheets that the data shuttle…
-
Do Data Shuttle Input Expressions work to build a key column?
I have this sample dataset, I want to test Input Expressions to upload data and have it mapped to the Unique Identifier Column, which is Column7. When I run this workflow, there are no changes done nor added rows. This is the formula I used in Input Expressions (I named it Column0): ="ID: " + [Column1]@row + " ; Name: " +…
-
Why are datashuttle workflows randomly failing?
I have a datashuttle workflow that is taking data from an excel spreadsheet attached to a smartsheet that is created by an automated process every hour with exactly the same data and columns etc but I keep getting error messages from datashuttle that the workflow maps columns that no longer exist. This will happen randomly…
-
Smartsheet Integration with MS TEAMS
Hello, I have been attempting to load a recently built Smartsheet to our IPPE TEAM Channel with no success, and depending on how I attempt to load it, I am getting different outcomes. Through Teams App, and Teams in Chrome browser, I click to load the tab, then just end up with the white screen below. No message to login,…
-
Integrate Smartsheet with Microsoft Teams
I created an "Assigned Tasks" report for the individuals on my team to access via Microsoft Teams. If I create a report in Smartsheet and create a filter that includes the teams names, can each person on the team go into the report in Microsoft Teams and filter it to show only their assigned tasks without it affecting…
-
Smartsheets Microsoft Dynamics Connector
Hi Smartsheets Community, Is there anyone in the Smartsheets Community or Smartsheets that I could contact to get a robust demo of how the Smartsheets Microsoft Dynamics Connector functions. Any help would be appreciated. All the best, Anthony D'Ambrosio
