-
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…
-
dependent actions
Can actions be made to be dependent upon another action? For example - Can I trigger an action to occur when a specific button is pushed and have the action affect a specific field in the same row as the button ? - specifically , I am wondering if I can populate a field with the current date (say field 3) when the button…
