API & Developers

Archives for November 2018

Smartsheet API Request Limit
Hi there, I'm hoping you guys can help me understand a problem I'm having, and maybe help me figure out a solution to it! I'm using Zapier to input some data in to a smartsheet. The problem I'm having is that every so often it will try to input about 100 data points at once, at which point I get a tonne of emails telling…
View Pictures on Mobile App
I love the ease of uploading photos to my SmartSheets. Viewing these photos is perfect from my laptop, it opens another tab and I can zoom or download the image. I'm looking for similar features in the Mobile App. I run Android. I cannot seem to open pictures beyond a thumbnail. Any advice?
C# API Media type not supported - Error 1124
Hi Guys, Trying API for first time. I am able to do GET sheet details successfully. But when i post to create new row/column i am getting the following error "Invalid Content-Type header. Media type not supported" for the below code var client = new RestClient("https://api.smartsheet.com/2.0/sheets/239613.../columns"); var…
Processing Limitations: List of formulas in order by relative processing power required?
Hey Community! One of my first requests. I dug around and so far haven't found anything, but my apologies in advance if this has been addressed elsewhere. My company has been bouncing off sheet limitations for a bit now, yet none of our sheets are anywhere near 10,000 rows (I separate into logical volumes as often as…
Revert to older version
Can I revert to an older version of a sheet from last night? In the history I don't see where someone sorted the rows, so I'm not sure what happened? I thought there was a way to revert to a certain time of day? I don't know anything about a back up so this information would be helpful too?
Smartsheet connection with Alteryx workflow
Hi, Someone facing an issue to connect data from Smartsheet into workflow in Alteryx? I have an Alteryx with data connected from Smartsheet that always worked well, but last friday the alteryx wont able to connect with Smartsheet, the message in Alteryx is "No valid Fileds were selected. This connection between Alteryx and…
Project Settings API
Does anyone see how to set the project date range in the project settings through the API? I need to create a trigger that changes the dates that respond to the predecessors from one set of dates to another set of dates.
Add row with multiple values in cell using c# sdk
One of columns has 'Contact List' type with checked 'Allow multiple contacts per cell' see example. I tried to add row using smartsheet-csharp-sdk(v2.3). Cell object: new Cell { ColumnId = 111111, Value = "Test@test.com", Strict = false } and I got the next error: { "errorCode": 1235, "message": "Value is not supported for…
Dashboard Widget
Hi, Is it possible to create a dashboard widget that contains an <iframe> with contents from another external site? // Leif
ODBC Connections and Outside Apps
Hi all, Hoping i can find some recommendations that can assist with an app development. I am creating a simple VS2010 Visual Basic app and report that will create purchase orders using smartsheet as the database back end. I have unlocked the smartsheet potential in ODBC connection but I am wondering if anyone has…

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