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…
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.
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…
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…
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!
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?
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?
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…
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!
Hi guys. We are making good headway pushing data from our CRM to SS with the API with VB and C#. One of our sheets needs to have a column with a list of (regularly changing) people for the users to select from in a ContactList or Dropdown control. I believe it is not possible to draw these lists from another source sheet…
