Stack Overflow
Stack Overflow

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
1
vote
1 answer

Is there a way to use SmartSheet Control Center to bulk add reports to previously created projects?

I would like to bulk update Dashboards in SmartSheet, via Control Center, to leverage new reports I've created at the SCC/template level. I'm having two problems. Is there a way to use SmartSheet Control Center to bulk add reports to previously…
Stephen OKeefe
  • 13
  • 2
1
vote
1 answer

Is there any way to modify the SourceSheets object in Reports

I have a script which periodically creates a new Smartsheet from a template, then imports data into that newly created sheet. I have a series of reports which looks at all of sheets this script creates so that I can present and graph each sheet as…
Ryan McBee
  • 13
  • 2
1
vote
1 answer

How to give a Smartsheet access to someone with API?

With PHP, I create a smartsheet from excel file with smartsheet API. Everything is working fine so far. But I also want to give right access to the new smartsheet to a specific user to allow him to open it from a browser. The user already has a…
Moustakime KIFIA
  • 33
  • 7
1
vote
1 answer

How can I get a smartsheet as excel file and put it to cloudinary in PHP?

I need your help to get a smartsheet as excel and put it to cloudinary in PHP. I use the code bellow. /** * @param $sheetId */ public function getSheetAsExcel($sheetId) { $url = self::SMART_SHEET_BASE_URL . '/sheets/' . $sheetId; $ch =…
Moustakime KIFIA
  • 33
  • 7
1
vote
1 answer

Iterate over rows in smartsheet and indent based on value in column using node.js

My Smartsheet and node.js world is expanding :-), but now something I don't know how to approach. I have a flat structured smartsheet with around 1000 rows and I need to indent selected rows using node.js. The system (for this example) is broken…
bowow99
  • 55
  • 7
1
vote
2 answers

Access Smartsheet by column Name instead of Column Id

I am a newbie working with Smartsheet, I am trying to access the values of columns and store them in a list, and I am able to access the values by the index. In my use case, people can delete random columns from the smartsheet and that can cause my…
Shrads
  • 883
  • 19
  • 39
1
vote
1 answer

Get hyperlink to sheet based on SheetID

I am importing a Smartsheet Report through Python, using an API. One of the columns in this report contains a hyperlink that works in Smartsheet, however when importing the report with Python I only receive the words of this column, and not the link…
Karen
  • 11
  • 1
1
vote
1 answer

Running simple_smartsheet on Python 3.7, unable to find 'pd' definition in read Excel call

I've looked through StackOverflow and found a related question about a script that reads an excel file, read the row from excel, then write the row to Smartsheet. I am getting an error where the 'pd' is not defined when I run the script to read an…
Michael Tuccillo
  • 11
  • 2
1
vote
1 answer

Using importlib.import_module over an import statement

I was using an api -- smartsheet-python-sdk that was running fine when executed from the source code. However, when I went to package using PyInstaller I was getting an error because PyInstaller couldn't find the necessary modules. In the smartsheet…
Warcupine
  • 4,460
  • 3
  • 15
  • 24
1
vote
3 answers

Smartsheet adding multiple contacts

I had the column in the smartsheet as 'Allowing multiple contacts to be selected'. I am using simple_smartsheet package (https://pypi.org/project/simple-smartsheet/) but I cannot seems to find in the internet that anyone adding multiple contact…
kevin hiew
  • 96
  • 1
  • 7
1
vote
0 answers

Smartsheet API "There was an issue connecting"

When trying to create a new sheet with the C# SDK I get an error "Smartsheet.Api.Internal.Http.HttpClientException 'There was an issue connecting" This is an Asp.net application in Visual Studio 2019 using IIS Express. It worked fine when writing…
Jordan Moody
  • 11
  • 2
1
vote
1 answer

Need to create a hook for the smartsheet-python-sdk and PyInstaller

Ok there is a lot of information here but it's the result of me searching for days for this solution. I've seen so many people ask this question in various forms with no good answer and I think I'm really close to solving it! I have a fully…
Maddison Lussin
  • 13
  • 2
1
vote
1 answer

How to resolve Connect to api.smartsheet.com:443 [api.smartsheet.com/ip] failed: Connection refused: connect?

I am trying to Get Response from API through Httpclient, but I am getting org.apache.http.conn.HttpHostConnectException: Connect to URL failed: Connection refused: connect error. I am able to get the response using PoSTMAN Tool but not through…
abdul_hussain
  • 11
  • 3
1
vote
2 answers

How to delete a column with conditional formatting rule using smartsheet C# SDK?

How to delete a column with conditional formatting rule using smartsheet C# SDK? We are getting error - "The column specified is used in a conditional formatting rule, so the column cannot be deleted and its type cannot be changed." .
Buddhadev Karmakar
  • 11
  • 1
1
vote
1 answer

What will be re-direct URL of mobile app for smartsheet

Beginner programmer here. I am trying for third party app development from Smartsheet api in React Native. Just following OAuth flow which is mentioned here http://smartsheet-platform.github.io/api-docs/?javascript#third-party-app-development Here…
Adeel Tanveer
  • 13
  • 3
1 2 3
…
35 36