-
Connectors: Sync Smartsheet with Salesforce or Service Cloud
In Smartsheet / Salesforce Connector Workflow; once you're about to save: Does anyone know why "Opportunity: Counting the number of records to be updated..." would spin forever instead of saying there's no salesforce opportunity records to update? The workflow is bidirectional but the data is only going from salesforce to…
-
data mesh
Hi, I would like know why a yellow blox appear when I would like to do a data Mesh
-
DataShuttle adding values as strings
Hello, DataShuttle has started inputting values via upload workflows as strings rather than numbers. The source data is in normal number format, but when uploaded into Smartsheet they have a ' in front of them. This has only started occurring this week and was working normally before.
-
Unable to edit Blueprint in Control Center (I am Primary Lead)
Hi All, Hoping for some help that I have been unable to get from Smartsheet Support. I am the primary lead of our Blueprint, but when I go to edit the blue print I can get through the Blueprint Basics tab all the way to Profile Data Selection and then the site freezes up. While the Blueprint and provisioning work…
-
JQL query is working in Jira but Not in Smartsheet Connector -RESOLVED
RESOLVED - I am trying to use JQL to pull stories from Jira that meet the correct criteria. I need to use a text function to pull those that start with "APC" This query works in Jira project = 'AS' and (project = "AS" AND "Forcasted Release[Version Picker (single version)]" ~ "APC *") order by id Yes there is a typo on…
-
How do I find the ID of a Custom Field?
I am setting up a Bridge integration to pull a utilisation report from RM. The report i'm building needs to among others include filter on a custom field. In the configuration panel it tells me I need to add the ID of the custom field. Running the workflow with all the rest of the filters works as expected, so the issue is…
-
In Sheets- automating Status in Smartsheet from Jira
Is there a way to automate a column in smartsheet with a workflow from a webpage? Below is my Smartsheet, the final column needs manual update, but I'd like to automate. Below is the web page which has a current workflow pattern, i would like for the updated status from this page to automatically update on my Smartsheet.…
-
Use DataMesh to combine multiple sheets
I'm trying to combine multiple sheets into one master list, what is the best way do the config for this please? I want it to pull in all values from source sheets, and if the source sheets gets updated I want it to automatically update the master target sheet. Sometimes the source sheets have duplicates so I want it to…
-
Data Shuttle & Google Sheets?
I need advice! I'm trying to use Data Shuttle to automate an export to a Google Sheet, then use that Google Sheet to feed a Google Data Studio dashboard (I can't use the Smartsheet d/b because I need to use d/b-level filters, which as far as I can tell aren't yet available with the Smartsheet d/b functionality). Here's the…
-
Smartsheet to Excel automated exports (40+ reports)
Hi all, i'm looking for a solution for automated export of reports from our 14 data sheets. Sheets are very big - 50 columns, ~100k - 300k cells. We need to generate specific 40 excel files filtered on 2 - 3 parameters (with a specific structure, i.e. First row of data starting on 8th row of excel file, specific heading…