API & Developers

Archives for February 2019

ODBC-Smartsheet connector
I am trying to add smartsheet connector in User DSN through ODBC Data Source Admin. It keeps on saying invalid username/password. I am pretty sure I am using right credentials. I can login to smartsheet with that. We recently enabled SSO for smartsheet. I even tried User API token for SSO login. I generated the access…
Field Employee time tracking software that integrates with Smartsheet?
I'm looking for a time tracking solution for field employees that integrates with Smartsheet. In our organization we have a master project list sheet that compiles project data for all of our active projects. Our field installers are currently logging their time using T Sheets, they're clocking in/out as well as selecting…
Having viables on a form
I have a form that my company uses to enter new jobs on our manufacturing schedule, However we also do a select amount of installs. Is it possible to have the form be able to have a drop down menu (this i know it can) that when The questions is "Is this an install" the user selects "No" then all of the Install questions…
Automated emails
Hi, Is it possible to change the "from" address when sending automated alerts/update requests? Or is it always the default SmartSheet address? Thanks
Email Notification template
When I setup an email notification everything works fine. However, as an email marketing specialist it pains me to send out the data in such a standard (boring) template. Is there a way to edit the look of the emails that are generated through Smartsheets? This would be a huge benefit to helping sell this software to my…
Graphs 2 variables
Hi I wanted to know if anybody had tried to this type of graph in Samrthseet and if it's possible? Thank you for your help!
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
Smartsheet API - document generation and attachment to row.
Been struggling a bit with recent smartsheet api development and was hoping for some insight as to how to handle the following situation: To bypass the restriction of 5000 rows per sheet, I'm developing an app using NodeJS sdk that will run on a scheduler in the following fashion: If row count is 4500, next time this app…
Curl GET request mixed results
Hello community, Just getting started and trying to leverage Curl to proof a few things out. When I issue the following example command, I get a list of my sheets successfully: curl -X GET -H "Authorization: Bearer " "https://api.smartsheet.com/2.0/sheets" When I issue a more specific command listing one of the sheet ID's…
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…

Trending in API & Developers

Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…

API & Developers

Discussion List