-
Bulk update of parent ID (Python API)
I'm building a project schedule that represents an overall manufacturing production plan. The the resulting Smartsheet has roughly 7,000 rows. I've found a way to use bulk API calls for all but setting the parent IDs, which is now taking upwards of 20 minutes. Here's the basic flow: -- Create production schedule in memory…
-
I am identifying the duplicates in the sheet. What wrong with this query?
=RANKEQ([Request ID]@row, COLLECT([Request ID]:[Request ID], [Item Number (SUPC)]:[Item Number (SUPC)], [Item Number (SUPC)]@row, Duplicates:Duplicates, 1), 1)
-
Merged: Allow for updating report parameters via API
This discussion has been merged.
-
Return update request URL via Smartsheet API
Update requests can only be accessed via recipients' email. In this community discussion, several use-cases are described in which it would be useful for admins or developers to be able to access the URLs associated with update requests. In my organization, it would be extremely valuable to be able to access update request…
-
Create dynamic custom schedules based on selections in intake
Hi all, I recently developed a cool solution to an issue that we had... how to build a custom schedule based on selections in an intake form. This solution leverages Bridge, but you could do the same thing using a third party integration tool. THE GOAL The process goal for this solution is: Collect project requests using…
-
Merged: Expand Workspace Copy function to support more than 100 objects in the API
This discussion has been merged.
-
Save as new//100 sheet limit - work around?
Hi - Does anyone have a workaround for this? I have a client where i have stripped the workspace back to around 150 sheets - they need to be able to replicate this workspace. I'm getting the same error message when trying to copy the workspace via the API - The end result means that due to this limitation, someone has to…
-
Is there a way to bulk upload individual attachments to rows utilizing a unique identifier column?
-
Excel-to-Smartsheet Capabilities
Can you programmatically setup a filter in an Excel file and take the results of the filter and put the results into an existing Smartsheet?
-
Bridge & Resource Management Integration - Per User Per Project Utilization
With Bridge, we have been able to get ‘per-user utilization’ during a custom timeframe from resource management. Which provides us the User’s name and ID along with their utilization for that timeframe. Using this metric, we are attempting to get user utilization by project. (User hours assigned to a project, during a…
