-
Why no Move/Copy Methods for Reports
SheetResouces has MoveSheet & CopySheet methods, why are there no MoveReport / CopyReport Methods for ReportResources in the API ??
-
Auto user provisioning
Can someone explain to me what will happen if I enable auto provisioning in Entra with our groups that are already setup in Azure AD? We already have users using smartsheets. They have had their Azure accounts given groups that coincide with the Smartsheets groups, but I'm just wondering if a user was not granted the group…
-
Row Grouping with API
Is it possible to achieve Row Grouping using the api? I would like it to look like this However, when trying to upload the data with my python script it looks like this Thank you!!
-
Delete/Remove/Clear Hyperlink using API
While there are a wealth of articles, discussions, and examples of adding and updating hyperlinks in cells using the Smartsheet API, I struggled to find any concrete guidance on how to remove a hyperlink or clear a cell that contains one via the API. I need the equivalent of going into the sheet, hitting "Delete" in the…
-
How do I determine the Root Domain for a Smartsheet Installation?
I have a customer who has several domains added to their Smartsheet installation, and I'm trying to determine how to idntify the original root domain, or the domain that was used when Smartsheet was originally implemented for the customer. Is there a way to identify the root domain? Thanks.
-
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?
-
Adding Sheet to Report using API
After some trouble with this command line string. I am getting a 1006 error even though I am the Owner of the Report and Owner of the Sheet that I am trying to insert. I can do this manually without any issues. Any thoughts? curl -H "Authorization: Bearer TOKENHERE" -H "Content-Type: application/json" -X POST…
-
Multiselect Drop Down (Columns) and Export (Excel) or API
We have several multiselect drop down columns in our sheets that get either exported to Excel or get sent to other systems via an API; when it exports or the other "systems" receive the data that field / cell (which has multiple items) will not separate the items by anything (not a comma, colon, space, etc.). WHY? The…
-
Remove/Delete existing hyperlink using API
Per the problem outlined in the below community post, it appears the API is unable to remove existing hyperlinks from cells. It is possible to add or update hyperlinks, but not delete/remove them. Please add the ability to either completely clear cells (including hyperlinks) or remove just existing hyperlinks using the…
-
Primary Columns in Grouped Reports: change label locations and move column
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…