-
Resource Management API Errors - Update User Custom Field
I have been getting receiving error messages when trying to update the custom field values for any user. Issue: When attempting to update a user’s custom field value, the response is a HTTP 500 Response Code. Steps Taken: Ensured auth header is correct. Reviewed the following the documentation,…
-
Order of columns and Row-Cells in response to API Get Sheet request
Hello. In general, I understand that Smartsheet has made it clear that no order of properties or even any order of array entities may be assumed or inferred to any response to any API request. And fair enough. My question is about the response to a single invocation of the API GET SHEET - GET…
-
Gannt task bar % complete visual wipes out formula and forces static text
I have made a column with % complete based on todays date (using a formula) and it works great. I want to use this dynamic information to display the % complete on the Gannt task bars, but when I activate that setting, the formula gets wiped out (and forced to static text format). I can figure out a work around, but I…
-
Some attributed of "Sheet" object is not documented but is present in API response?
I noticed that some of the fields/attributes related to "Get Sheet" API has attributes like: which are not documented in the API doc https://smartsheet.redoc.ly/#section/Sheet-Object Could you please help in knowing what exactly is the reason to this? Are these to be considered?
-
SOLVED API - Finding a user using the email address not the {userId}
Good day, SOLVED! users?email= I have read the API documentation and see that you can query users using the identity {userId}. This of course assumes that you know what the {userId} for a particular user is which is rarely the case as this is generated by SmartSheet and not by the corporation using SmartSheet. The…
-
How do I generate a text value output based on multiple inputs
Is there a formula that will let me create an output based on selected input of text (not sum of numbers) So i am trying to create a specific output eg if I select the components of an item based on multiple options it gives me the closest output let’s say I select sand, cement, water and it gives an output of concrete.
-
How to avoid webhook triggering from cell format updates???
I'm using make.com to do some automations when certain columns in a row are updated. Works great until someone re-aligns the columns and updates 1500 cells at once, sending my webhook 1500 requests. I can filter them out by detecting the actual data cell history, but it still uses 3000 operations for no reason and ties up…
-
Form Customization
I was hoping there is a way to tap into the HTML of the forms to customize them a little more. I'm specifically unimpressed with the spacing options. The form looks as though it's made for mobile devices only. Also, is it possible to group questions? Ie all relevant questions enclosed in a box, same background color, etc.…
-
Smartsheet API in Python: Inaccessible 429 Response
I am trying to understand / plan for the rate limits, particularly for the get_cell_history method in the python api. When I run the code below, I see the following response printed to my console: {"response": {"statusCode": 429, "reason": "Too Many Requests", "content": {"errorCode": 4003, "message": "Rate limit…
-
Use API to detect change on ANY sheet?
I know you can use the API to poll for changes on a single sheet or a webhook to send changes whenever an individual sheet is changed. However, is there way to monitor an entire workspace (or the entire account I guess) for any changes that are made to any sheet?