-
Facility Bookings
Hi all. We manage many government/public venues and facilities (sports arena, stadium, parks etc) for which we facilitate bookings. At present, bookings are logged using outlook only viewed by one person. We'd like to begin using smartsheets for bookings so clients (the public) can view available (or unavailable) dates,…
-
Automation - 'change a cell' not operating until I close & reopen the grid.
I am using a series of automation workflows to change the contents of a cell based on the contents of another. Whilst trialling these workflows, I have to save, close and reopen the sheet for the intended cell to actually update. I would prefer this to be instantaneous. Is there a known solution to this? Thank you.
-
Event Reporting 403
Hello everyone, Hope you are well. I am trying to access Event Reporting through a API call following the respective documentation https://smartsheet-platform.github.io/api-docs/#get-events. My account belong to an Enterprise plan and I am System Admin. Also I generate the API access token multiple times but I am still…
-
Smartsheet API Assistance Required
I am looking for assistance to provide a url to find the correct row of a given sheet per the provided identifier (country code; e.g. US, GB, AL, etc) and return all the values of the row. I'll need the correct smartsheet api url of our smartsheet account (please don’t refer me to the smartsheet api docs), no application…
-
Querying API for 10000ft Time Entries
Hi, I am wondering if it is possible to query the 10,000ft API to retrieve time entries using parameters to limit the results to only include approved time entries after a certain date. To this point I have not had success passing in parameters for the status of the approval or the approved_at timestamp. I have reviewed…
-
Postgres SQL and updating records in Smartsheet
I am trying to keep an up to date list of different job information in Smartsheet. I would like to use this up to date information to reference data across different sheets but am struggling on how to exactly do this. I have a Postgres SQL API with the information I need, but can't seem to find a way to keep these records…
-
Workspace Shares - API (cURL) Error 1004 - Not Authorized to Perform This Action - 403 Forbidden
Hi all, I'm getting following error when trying to GET a list of workspace shares (GET /workspaces/{workspaceId}/shares) "errorCode": 1004, "message": "You are not authorized to perform this action." The same happens when trying to GET a specific workspace share (GET /workspaces/{workspaceId}/shares/{shareId}) Following…
-
Apostrophe added on mass insert thru CDATA
Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an apostrophe to Smartsheet. The only thing I can think of is Smartsheet is adding the…
-
"Make owner" using API
Hi, everyone. I want to change ownership of 100+ sheets that I own using the Smartsheet API. I have been looking through the documentation and could not find how to do it. According to this post on stackoverflow it is not possible. Performing this actions within Smartsheet interface is really tedious because you need to go…
-
Smartsheet data connection in TIBCO Spotfire server
I am able to create an ODBC connection and get smartsheet data in my Spotfire Analyst client. I followed this link - https://smartsheet-platform.github.io/odbc-docs/#tibco-spotfire-desktop. However, I would like to create an information link and publish data in Spotfire library and share the web link with the users. The…
