-
How to get createdAt, modifiedAt and workspaceInfo with list reports call ?
Hi all, I am using this endpoint https://api.smartsheet.com/2.0/reports/?include=ownerInfo&includeAll=true&pageSize=500000 to get reports info but noticed createdAt , modifiedAt and workspaceInfo are missing. Can someone please help us here ?
-
Multiple query parameters using the API's Search Sheet Method
Hello, I need to find out the ID of a line where the column "Column1" has X value and Column "Column2" has Y value, that is, my query has two parameters. (column:Column1 "X" column:Column2 "Y") GET https://api.smartsheet.com/2.0/search/sheets/{sheetId}?query=column%3AColumn1%20%22X%22%20column%3AColumn2%20%22Y%22 I found…
-
Database, Infrastructure, Coding
What database is Smartsheet running on? (SQL serves, MongoDB, Proprietary, etc.) What cloud infrastructure is Smartsheet using? What programming languages can I use? (HMTL, JavaScript, CSS, JQuery, SQL expressions, etc) Are there built-in functions as well? Hope someone can help! Thanks!
-
Bridge Add columns based on values within multi-picklist
Overview: We are managing the schedules of providers / resources in Smartsheet where each provider may be licensed in a variety of different states (Alabama, Alaska, Arizona, etc.). These providers / resources currently enter their shift availability into a column with their name within a Centralized Availability Tracker.…
-
Bridge - Is it possible to get Workspace URL?
Is it possible to get the Workspace URL via Bridge? Tried using both Get Row and Get Sheet functions but only see the Workspace ID.
-
Failing to post date value to Summary field
I am working with the python sdk, and I cannot figure out how to post a date value. Here is a picture of what I am doing. where sum is a dictionary of posting data If I am trying to post a formula, I check that my "Posting value" has a equal sign, and then the formula goes there, and it posts fine. If I am trying to post a…
-
Is there a better way to completely remove user access via the API?
Hello, We're beginning to look into integrating the removal of a user's Smartsheet account as part of our employee offboarding process. My intent was to use the API for this functionality so that it could be automated. Unfortunately, I'm not finding the API endpoints available to accomplish this task in a relatively small…
-
Does Smartsheet have a way to create a flow chart for account current pages?
Does Smartsheet have a tool that could map out the pages within my organizations Smartsheet. Like a work flow diagram that shows where the pages go, what reports link off these pages, what dashboards they are attached to etc. Maybe even what/who is linked to the Automation's. What automation's are included on the page and…
-
Use smartsheet data to generate a document that maintains fillable blanks for the recipient
Use: We are using smartsheets to maintain client progress. We have forms that are pdf fillables mapped. We generate these and then email them to the account manager. At that point, the manager still has information to complete ie- other questions on the form that were formatted in acrobat pro to have fillable blanks that…
-
How to add cell dependancies using (python) API
Hi community! I'm not the API dev, just asking about API capabilities. I know its possible to create dependencies in the GUI by specify a row number for example. If we're creating via API, we may not know the row number. Is it possible to specify the relationship by cell "Task Name" for example. Can I specify a dependency…