Questions tagged [smartsheet-api]

The Smartsheet API provides developer access to Smartsheet features and data

The Smartsheet API provides a REST interface to Smartsheet features and data. The API enables Smartsheet customers to programmatically access and manage their data, and empowers application developers to build solutions on top of Smartsheet.

For more information about the Smartsheet API, please visit and bookmark the Smartsheet Developer Portal. There, you’ll find links to the API Documentation, SDKs and sample apps, and other ways Smartsheet can make your API integration easier.

Repositories of sample projects can also be found on the Smartsheet Platform GitHub page at https://github.com/smartsheet-platform.

Smartsheet, a leading Software as a Service (SaaS) company, offers businesses an intuitive online collaboration tool. The ease of use of the familiar spreadsheet-like interface, coupled with file sharing, work automation and Gantt chart features, have made it a popular and highly functional collaboration and project management tool for nearly 2 million users. Customers include construction companies, consulting firms, schools and universities, utility firms, government entities, healthcare organizations, high-tech firms, non-profits, manufacturing and law firms, among others. Additionally, Smartsheet offers mobile apps, pre-built templates and integrations with leading cloud apps such as Box, Dropbox, Salesforce, Google Drive and Zapier to ensure users are up and running quickly. Visit http://www.smartsheet.com for more details.

530 questions
0
votes
3 answers

Setting precision in PHP

I have installed PHP 5.5 on my laptop, who's running Windows. I'm accessing Smartsheet API, and I supposed to get a column id a number with 18 digits(or sometimes 17). But I get a scientific number: 1.5441916385627E+15, not 1544191638562692 I ran…
dpuscau
  • 11
  • 1
0
votes
0 answers

An Object reference is required / Can't call Request from reference

I'm currently trying to make a new Umbraco document, then request into query a string Rid and run my code (which will find the id of the page and display correctly hopefully) but I'm not able to call the reference request while it is a asp.net user…
Alex
  • 673
  • 3
  • 9
  • 22
-1
votes
0 answers

Want the smartsheet data on wordpress site with proper layout

My name is Ashutosh and I am looking for the solution. I saw somewhere that by fetching the smartsheet API we can get the data on the wordpress site frontend in stack over flow.I saw that this case is achievable but we need to write a proper backend…
-1
votes
1 answer

Is there a function to use in Python to pull an attachment from Smartsheets?

I am trying to pull information from the Smartsheets API- I can successfully get values of the cells and column headings. I am not using the SDK for the site, as it was not working properly. There are attachments on some of the rows and I would like…
reiem87
  • 1
  • 2
-1
votes
1 answer

Power App writeback in Power BI with Smartsheet

I'm trying to use Power App embedded in Power BI to writeback data source from Smartsheet. However, I was not able to choose any of the sheets that has been listed from the newly created form in Power App and the "Add Field" option was disabled. I…
Emi Shang
  • 1
  • 1
-1
votes
1 answer

Need solution to "The app returned "The columnid xxxxxxx is invalid"" when using Zapier New Row Update for Smartsheet

I'm looking for a solution to a problem that's occurring when using Zapier to update cells in one smartsheet from cells in another smartsheet. When using the Zapier New Row Update action on a Smartsheet, it's throwing an error: "The app returned…
-1
votes
1 answer

Need to change Access Control of Published Items though api

In Smartsheet I have downloaded Published Items list from user management. Using this list I need to change the Access control (Public/Organization) value through api. Please help. Thanks
jeeva sr
  • 5
  • 4
-1
votes
1 answer

Excel to Smart Sheets

I am need to convert my Excel sheet into Smartsheet. I tries to upload the document from Excel and Google Sheets but tbe formulas do not transfer. How can I create new formulas in Smartsheet that correspond with the formula in Excel or Google Sheet.…
-1
votes
1 answer

Smartsheet function is UNPARSEABLE

On the Sheet Summary I'm trying to write a function that will track Past Due tasks below is the format : =COUNTIF([Is Past Due?]:[Is Past Due?], "Yes") The formula doesn't work as it says "UNPARSEABLE". Below is the Past Due column name
agega
  • 157
  • 3
  • 13
-1
votes
1 answer

Parse variable into command without brackets

I'm trying to create a variable with multiple numbers which is then parsed into a code to delete multiple rows via Smartsheet API. This is how it works: smartsheet_client.Sheets.delete_rows( 3637721312342212, #sheet_id [567387105060740,…
TobeT
  • 3
  • 1
-1
votes
2 answers

Qlik Sense and Smartsheet

Can we connect online interface of Qlik Sense to Smartsheet? If yes, can the data be refreshed automatically in regular intervals? If no, is there a suggested alternative to Smartsheet that can connect to Qlik and refresh automatically. Looking for…
-1
votes
1 answer

Sync smartsheets to postgres table?

Is there a way to copy the contents of a smartsheets table to a postgres table? We would like to schedule this as part of our ETL pipeline. Hoping to avoid using a third party service like zapier or integromat if possible.
user2491463
  • 414
  • 1
  • 6
  • 16
-1
votes
1 answer

Smartsheet API - ModuleNotFoundError

I have been battling this for a few hours now. Trying to use smartsheet-python-sdk on my new laptop. The script I have works perfectly on my old laptop. I am on OS X. Both are running Python 3.7.4 and I have been through pip list on both and…
-1
votes
1 answer

How to update link attachments using smartsheet c# sdk?

I have a smartsheet with a bunch of link attachments. I'd like to replace the beginning of the links with a different substring. I am new to smartsheet and have not been able to find much sample code. Sheet setup, SmartsheetClient smartsheet = new…
-1
votes
1 answer

How to use Smartsheet API to obtain data from Quickbooks Desktop

We would like to pull data from Quickbooks Desktop into Smartsheet. Eventually, we would like to push data the opposite way. I've researched Smartsheet API & SDK and also Quickbooks Web Connector and QB SDK. I just can't figure out how to make them…
ajsmith
  • 13
  • 4