-
DataMesh config scheduled, but not executing
We are using smartsheet to share information between functional groups and DataMesh is the primary tool used to copy/paste the information between sheets. Recently (within the last two weeks), I have come across several datamesh configs that are not running during scheduled times. If it is set to hourly, the datamesh card…
-
SmartSheet Names and Same Sheetnames in SSIS Differ
Hello, The sheet names differ in Smart Sheet and SSIS, the same sheet is shown with different names in SSIS when reading it via smart Sheet ODBC. Sheets in SmarSheet.Com Sheet in SSIS 801 Centre Road801 Centre Road__8524479023343492s_(Home) Canterbury Road Canterbury Road__4221359879415684s_(Home) Burke Road Construction…
-
Auto Cell Linking With Templates
I need a way to auto link a row from new sheets with a master sheet because I am constantly using a template to create new project sheets containing the same info categories on each one but it takes up to much space to have all the projects on one sheet so i opted for individual project sheets. I need to be able to add key…
-
Linking to data on SQL server
Does anyone know how I can link to data on an SQL server so that I can create a dynamic sales pipeline with data drawn from estimates actually created?
-
Outlook for Windows
I am trying to add the Outlook Add in. I just got Office 365 business. It installed outlook on my Windows 10 and brought over my old emails and email addresses. But I can't get it to integrate the Add In. It had me set up a .on.microsoft.com account, I have a feeling this is messing me up somewhere. Any thoughts? I am sure…
-
Salesforce and Smartsheet Integration
Hi Everyone - Have any of you used the new Salesforce/Smartsheet integration with project plans? I see and understand how it can push and pull data as reports between the systems, but I need to figure out how to take a cell in Smartsheet (Due Date or Date Completed for instance) and map that specific cell to a specific…
-
Sprint Name field
How can I get the Sprint name field to pull from Jira to Smartsheets? The Sprint field is not showing up as a field in the Jira + Smartsheets connector for me to sync.
-
Limit to the number of Smartsheets linked to one JIRA board?
Hi guys. I am setting up a workflow where a bunch of Smartsheets, each representing a different project, feed into one big JIRA board. Each Connector workflow has a JIRA filter that makes sure only the issues associated with a given Smartsheet get synced back, so every JIRA ticket is ONLY linked to one Smartsheet row (I…
-
Smartsheet-JIRA sync via formulas?
Hi guys. I'm using the Smartsheet-JIRA connector. I have a workflow where the Status of each JIRA ticket flows back into Smartsheet. Then formulas in Smartsheet change the Priority of a row once its predecessor is complete. The idea is that you have a bunch of tickets in JIRA that are marked as priority Blocked if they…
-
Box.com Integration
This is an idea for an improvement to the box.com integration. Ideally, SmartSheet would allow attaching a document from my desktop directly to a row in SmartSheet while storing the document in Box.com. For example: 1. Drag and drop a document to a SmartSheet row / attachment. 2. Automatically create a folder in box.com…
