-
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…
-
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?
-
Power Automate to save a Smartsheet attachment to SharePoint
Can you use Power Automate to save an attachment from a Smartsheet row to SharePoint? Alternatively, I need a way to link directly to the attachments in a sheet. Is either possible?
-
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…
-
Using a Cross Reference Sheet to update column using API
I'm looking to update a dropdown list referencing a column on another sheet using API. Reading through API documentation, it looked like I needed to create a cross reference sheet. How do I now use this new Cross Reference Sheet to update the column dropdown in my target sheet? Thank you!
