Add Ons and Integrations

Archives for March 2022

I made a workflow to link my smartsheet to a Jira project. However, my smartsheet is not updating.
I created a workflow to link my smartsheet to the primary Jira project our team uses. I did filter by assignee name as there are nearly 2000 issues in the project I am using. I know the filter is correct, however the smartsheet is not updating. Does it typically take more than a day for the smartsheet to update after a…
Calendar Merge
I have create an automated travel process in Smartsheet for our organization. I would like to know how I can link the Smartsheet calendar with an Outlook calendar so I can display it on a SharePoint site. Thank you
can I filter on a name field where the value contains more than one text string?
Using the salesforce connector workflow I wish to filter where team member name contains 'Fred', Bill', "florence' I see that I cannot create separate OR conditions as AND appears the only option. So can I achieve the same result another way?
Can I pull data from Tableau into Smartsheet?
Hi all! I know you can connect Smartsheet to Tableau, to publish Smartsheet data in Tableau but can you go the other way, and pull data from Tableau into a sheet in Smartsheet? I'm trying make things flow a little better for our team and reduce errors from inputting data manually. Thanks! Emily
Chart Widget
Hello Everyone, I am trying to create a Dashboard from the already existing Smartsheets. Now in the Dashboard, I tried adding the Chart Widget to create a bar chart with the Number of Yes and No from the column in existing smartsheet however its says the selected column does not charter, I guess as its not numeric. How can…
wild cards in DataShuttle
In the source sheet section, is there anyway to use a wild card in the Attachment Name? I have two exports that have a consistent file name at the beginning, but an inconsistent name at the end because it includes a date time stamp, so it would be very helpful to have a wildcard option here.
Dynamic View User Troubleshooting
Hi there Smartsheet Community, One of the Smartsheet users in my org recently changed her email address because she got married. Since this change was made, she has not been able to access the Dynamic Views she ought to be able to see. I have updated her email address in every conceivable place where it can be found -- all…
Data Shuttle and Join Collect formulas
Hello, I have a formula JOIN/COLLECT formula that works perfectly fine when referencing a vlookup sheet with manually entered data. Once that sheet is replaced with data shuttle workflow, the JOIN/COLLECT formula no longer displays data, resulting in an empty return (no error). All vlookup references properly reference the…
JIRA Connector not pulling in expected fields
Hello, Trying to use SS to pull data from JIRA but expected fields are not being populated. Specifically, The Epic Name field, clearly present in JIRA, fails to sync to SS. Message returned in SS is "Epic Name Not Set" and the Epic Name Column is blank Has anyone else had a similar experience?
DataMesh & Locked columns
Hello, Will Data Mesh still import appropriately if the some columns in the target sheet are now locked?

Trending in Using Smartsheet

Data Shuttle Error "Specified Key Does Not Exist"
In Data Shuttle, I have a workflow that is producing the following error: Unable to add rows to target sheet : UNKNOWN: The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87) This workflow has been operating fine for months (runs twice a day) with no errors and this just started…
Reupload Data with DataShuttle
Dear All! I would like to create a tool which uses Data Shuttle. Basic idea is to ask user to upload attachment (via a form) which would trigger a data shuttle and info in the attachment would go to a transition sheet from where it would be moved to the target sheet with automation. It works nicely, however, I need to…
Dashboard reports not showing on published dashboard in SharePoint
I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…

Add Ons and Integrations

Discussion List