-
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…
-
DSN architecture mismatch
When I try to follow the ODBC instructions for the 64 bit Live Data Connector to use it with Microsoft Excel or Access 2016 and the Smartsheet DSN I set up in Windows 10 using an API access token, I get the following error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the…
-
Notifications
Hi Guys, Im trying to set auto Notfication I have a Project sheet with Date type of coulmn called "Last Updated" I have another text Column Called balance Due I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column and if not do able with smartsheets…