-
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…
-
SheetNames appear differently in SSIS compared to SmartSheet
Hello, I am trying pull the information from Smartsheet Dynamically using SSIS. I see that the Sheet Names in SmarSheet is different to what I see from SSIS ODBC Source. For Example : Names in SmartSheet Displayed Name in SSIS * 801 Centre Road 801 Centre Road__8524479023343492s_(Home) * Canterbury Road Canterbury…
-
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…
-
Working with SS API SSL Error
I am trying to access my smart sheet from a php program via the API. Every time I run the program I get the following error, any idea why and how to fix it? (Bearer is my token) Error:Unknown SSL protocol error in connection to api.smartsheet.com:443 <?php $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,…
-
Web socket error while implementing smart search of Qlik Sense
I have followed the following code on github and cloned the directory. Qlik Sense smart search | QlikView Whenever I try to run the code, I am getting the following error. As I am very new to Qlik Sense I am unable to understand where the problem lies, can anyone please help me out on this? Regards SarahJohn
-
Trying to work around the 5000 row limit
Hi Guys, I know there are other questions on this, such as here: https://community.smartsheet.com/discussion/rss-feed But in the interests of etiquette I thought I better start my own thread. So I have a sheet where I add a new row at the top. Every three months or so I reach the 5000 row limit and have to move rows out…
-
OPen access to access data directly to google docs (spreadsheet) without exporting first
I have feature request on access of data to googlesheets...I want to access smartsheets directly from my own google sheets so that i can build my own fully custom dashboard using google sheets but from that i would need to be able poll the project data directly from smartsheets. I would like that.
-
Jira performance issues when connecting 50 + projects (and temp solution)
Hello, We did experienced some serious performance issues in Jira after connecting 50+ project to Smartsheet. I did find the problem and can be fixed by hand. I allready raised this issue with smartsheet hope they can add a fix soon. Problem explained: When adding a workflow with the smartsheet workflow manager, the tool…
-
Transferring information from one sheet to another when checkbox checked
I have a system whereby people are able to report issues by completing a form through smartsheet. Once the issues are clarified or resolved, I want to release certain information to other parties, but not all of it. I would like to be able to check a checkbox that says "release" and this will then trigger a transfer of…
