API & Developers

Archives for September 2019

Send - Function/Option
i was really hoping this was not going to happen. I have worksheets set up (at 14 facilities) to be able to "send" the row to themselves and then to the customer. I REALLY need this function back. I need users to be able to do this.
Move row API not working
We use move row API since 12 hours ago it has stopped working
Data Loader Expression Input value
I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
How can we update multiple columns in a smartsheet at a time using smartsheet C# SDK?
How can we update multiple columns in a smartsheet at a time using smartsheet C# SDK? We can update one column using UpdateColumn() API. How to update multiple column by one method?
Smartsheet token - expiration time
Hi, How to expand expiration time for token without using of SDK (no APPLICATION)? - I just needed it for simple csv download & then process it via Informatica Power Center. Just execution of script/cmd like this one: curl https://api.smartsheet.com/2.0/users/me -H "Authorization: Bearer xxx" -o…
Webhook "Error Code: 1151 - Scope 'sheet', object id <id> was not found"
Working on implementing a basic webhook based smartsheet connector to fetch usage data for users under one organization. During the Oauth2.0 flow, requested for following scopes "READ_USERS, ADMIN_USERS, ADMIN_WEBHOOKS". I am making the following javascript-sdk api calls : - - smartsheetClient.users.listAllUsers…
Conditional Logic in Smartforms (AKA Cascading Dropdowns)
We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsheet) is the need for Conditional logic or Cascading Dropdowns when completing forms in…
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.

Trending in API & Developers

COUNTIFS and OR
Hello, I am having trouble getting my COUNTIFS formula containing an OR to work. I need it to count based on range 1 and a second column containing either Planned or Submitted. =COUNTIFS({RegSci Review Projections Range 1}, [Primary Column]@row, OR({RegSci Review Projections Range 2} = "Planned", {RegSci Review Projections…
When a new row is created in Smartsheet, Create SharePoint List Item
I'm trying to do my first Smartsheet Power Automate flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List. The part that I need help with is the mapping of the columns from the SharePoint Create…
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,

API & Developers

Discussion List