-
Office Status Calendar
My company has been researching on how to track the status of the employees working in office. We created a sheet where each day of the week, not including weekends, is a dropdown column with the choices of: • IN OFFICE • REMOTE • OUT OF OFFICE We also use conditional formatting for each column where if it selection is IN…
-
Limitations of Using includeAll=true in the Smartsheet list sheets API
hi team I saw in the documentation that using includeAll=true can return all data, such as the list sheets endpoint returning all sheets without pagination. I’d like to know if there are any limitations to this. For example, is a very large list supported, such as one with hundreds of thousands of sheets? Best wishes Buren
-
Documentation Discrepancy in "List Report Shares" API Parameters
Hi Team, I hope you’re having a great day. I have a question regarding the List Report Shares API and its parameters. The documentation mentions using sharingInclude=workspace, but it seems to have no effect on the response. Upon reviewing the Java SDK source code, I noticed the parameter include=workspaceShares is used…
-
Warning Banner?
I need to have a warning banner available any time someone opens Smartsheet. I'm thinking similar to when Smartsheet announces changes or upcoming events. I have a Welcome screen set up but that is only once (unless I reset it). There are places that I have built in the warning (i.e. top of the dynamic view and on some…
-
Is there a way to change a filename automatically?
Hi Everyone, I have been looking to change the filenames for uploads automatically using the Smartsheet cell. I am not sure if I would have to code this myself using the API or if there was an automatic way to do this within Smartsheets! Thanks!
-
Smartsheet Error when trying to Publish a dashboard
I got an error when trying to publish a dashboard to use it as an embedded link (iframe). I have tried exiting and reloading Smartsheets, restarting my laptop and changing the permissions so i am the only admin/owner and it still gives me the same error. Please help, thank you. Error: "We ran into an error. Please refresh…
-
Is it possible to add child rows to multiple parent rows with a single API call?
I am attempting automate adding standard sub/child tasks to many parent tasks at the same time. Following the API documentation Specify-Row-Location I am using the parentID + toBottom location attributes for every child row. I am consistently getting errorCode 1123 when the program moves from the first parent row to the…
-
Get login activity for external users —equivalent to the User Type Report
What's the appropriate method I can use to return the equivalent to the User Type Report that one downloads in User Management? Basically what I want to retrieve is the following info: Email, Highest permission given on assets, Last activity, and Number of asset views by user. With the List Users method I can return the…
-
Export excel file via API
I want to use the API to export an Excel file. While reviewing the latest documentation, I couldn’t find any reference to this functionality. However, I discovered in historical posts that using the Accept: application/vnd.ms-excel header can achieve this. I tested it with the API, and it worked successfully. Could you…
-
Message Error in POWERBI 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error
Hi everyone, I use Smartsheet as database for mis PowerBI reportes. The problem is, when i try load the data with Refresh in PowerBI, appears the following message: 'https://api.smartsheet.com/2.0/home' (500): Internal Server Error I tried with another sources, and works fine, the problem is only with Smartsheet. Any…
