-
Get a sheet URL with the Sheet ID [API]
I'm using Python and I want to get the URL of a sheet if I know its sheet ID. I try to create a list of hyperlink thru the API. I already have access to the sheet and I could copy the url by hand, but that is not the point.
-
Smartsheet API - Is it possible to create a copy of a sheet and maintain the row and column IDs?
Is it possible to use the Smartsheet API to create a new sheet from a copy of an existing sheet, but maintain the row and column IDs? Ideally the output would be 2 sheets with unique IDs, but the row and columns within each would have identical IDs
-
Logging and tracking cross-sheet functionalities
Hello! My organization uses cross-sheet functionalities (formulas, workflows and API) pretty intensively. So much that when we are working through ideas to embed new processes, it can be a bit cumbersome to understand what is already at play. Essentially, we do not have any type of log or systems map to reference where or…
-
API to provision (copy template folders) in SharePoint from SmartSheet
Has anyone created an API app to provision a set of template folders in SharePoint. Basically to copy and rename as required? I think I can do this via MS Power Automate, but a moire direct may be better.
-
Automatically Organizing Rows into Hierarchy
Hello SS Developers! I am both a formula and API-deficient SS user. I believe my question should be directed toward the API/Developer community, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy". I…
-
Report Grouping: custom sort order of groups
Current limitation: When grouping by a column in the report, I’m forced to choose either Ascending or Descending order. This prevents me from grouping without altering the original sort order based on another column. Request: Please allow grouping by a column without forcing a sort order on it. (Also would be great to…
-
Admin - update user email address
It seems that there are only 2 ways to update a user's email address. 1) I have to create a new account, have that user accept the invitation, and then merge those two accounts together 2) Have the user login and update their email address. While it seems simple to have users go in and update their email address, this is…
-
Attach a file to a Row
Hello, I am unsure what this is and how to get it in order to attach a file to a row in Smartsheet. Can someone please help? Examples would be great. Thank you!
-
Long-working API requests now responding with 500 "Unexpected Error (ExtAuthN)"...
API requests like the following (that have been working flawlessly for months)… GET /2.0/sheets/542002634510212?level=2&include=objectValue" are suddenly responding with 500 errors and the message "Unexpected Error (ExtAuthN)". Status page does not show an issue. Can you help debug?
-
Using Copy Sheet API to copy column data and not formulas ?
I am trying to use the Copy Sheet API call to take a snapshot and archive on a weekly basis what has been entered into a source sheet. The source sheet has many formulas but I only want the data copied over. So far the source sheet is getting cloned over with formulas. I cannot have the copied formulas in the target sheet…