Add Ons and Integrations

Archives for June 2019

Setting date in Project profile data from Master intake form
Am I missing something? I've been trying to push the start date of a project from the intake sheet (via intake form date input field) without success. Upon spinning up the project in SCC, I get the error: * Failed to update template field(s) for "Project Profile Data" (Code: 5536 - Message: The value "04-27-2018" could not…
Alerts to Microsoft Teams
When trying to set up an alert to Microsoft Teams from a Smartsheet Workflow I am getting the below permissions message. I have spoken to my Office 365 Admin and he is not sure what to do. Is there a link to an instruction on how to do this. This seems like it should be straightforward but I can't find anything.
Dashboard Viewing - Send as PDF
There are options to send sheets and reports on a recurring basis, but there is currently NO way to send a Dashboard as an email attachment on a recurring basis. The dashboard link is difficult to view on an ipad or mobile device. We would love to see the option to send a dashboard as a pdf or png attachment to an email on…
Apostrophe being inserted before number when importing from web form
I am using MS Forms to collect information and using an integration through Flow to insert responses into Smartsheet. Answers that require a # (I.E. salary or years experience) are being inserted into Smartsheet with an ' before the number which results in my formulas not working. I need to find a way to make this work…
Help with Google Forms sync
Hi All, I am trying to create a procurement Smartsheet for my company, using Google Forms as a method of collecting data for procurement requests. The reason I am using Google Forms is that it has form logic, which is something the people at Smartsheets have not implemented yet, but are working on from what I am being…
SmartSheet / ServiceNow interface
What is the interface between SmartSheet / ServiceNow and can it be an automated rather than a manual extract which can be extrapolated into reports from Smartsheet?
Create a Link to A Filtered Sheet
Does anyone know of a way to link to a filtered sheet? I want to create a number of links on a dashboard which when clicked on will show the same smart sheet but with a different filter applied. e.g. I could have a link that says "Red items" and another that says "Blue Items" the interaction on the link would be to open…
Getting '...is not a valid user for the given JIRA project' sync error with Jira Connector
Does anyone know how to correct the '<user name> is not a valid user for the given JIRA project' sync error when using the Jira Connector tool for Smartsheet? This error just started appearing and no project permissions have been changed in our Jira account. We have all projects set to allow issue field read/write…
iOS 13 and SmartSheet
For any Apple developers, have you tried the beta version of iPad OS, Safari and SmartSheet? I am so wanting to eliminate carrying my Windows laptop just for SmartSheet administration. The current SmartSheet apps don't allow it and neither does the mobile version of Safari in iOS 12. Please let me know your experiences so…
Jira Sub-Task Link
Using the Jira + Smartsheet connector, I am having difficulty getting the Parent of a Sub-task to show. When adding Parent Link from Jira it receives this message in the sheet: {"hasEpicLinkFieldDependency":false,"showField":false,"nonEditableReason":{"reason":"SUBTASK_LINK_SHOULD_BE_USED","message":"To set the parent for…

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