Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Batch Update Request
I would like to send update requests for different rows to the 'assigned to' field in a batch request.
Multiple update requests at one time.
My specific purpose is to send out requests for proposals and collect PDF responses along with other information about the proposal and template the process to apply to multiple projects.
Comments
-
Hi Jeremiah,
Great question and scenario.
At this time, it's not possible to send Update Requests in bulk based on the contents of a Contact column.
If this is something you do regularly, it might be worth looking into creating a custom solution for this. The Smarthseet API makes the values in the Assigned To and the Send Update Request feature available, so the product could be extended to do this. If you're not a developer type, Smartsheet has resources available to help and there are partner firms available that do this type of work as well.
Here's a link to the Smartsheet resources for more information:
https://www.smartsheet.com/support#Consult
Thanks for your question ... and note that I will add your vote to the Smartsheet Enhancement Request list to allow the app to do this natively (i.e. without needing to craft a customization).
Cheers!
Gwyneth
-
Hi Jeremiah,
I was looking for the same functionality and figured out a workaround.
You can set up an update request action that will send bulk update requests to the assignment column based on the rules of the action.
Steps:
- Create a checkbox "Request Update" Column in your sheet
- in Alerts & Actions create a rule that will send out an update request
- set the parameters of the rule that will fire the update request.
- When the following change occurs: "Request Update" column changes to "Checked"
- In any row where "Column X" is "blank" (or whatever)
- Send undate request to "Contact in column" "Assignment"
- In the Delivery Settings hyperlink in the bottom of the Edit Rule window you can select which columns you would like updated.
- Once the rule is created you can bulk check the "Request Update" checkbox column and the update requests will be sent to the "Assigned To" column in each row.
Hope this helped.
Andrew
-
Hi,
Once the checkbox is "checked", is there a way to automatically uncheck it when the rule is fired? Otherwise, if the user updating that row doesnt "uncheck" it, it will keep going in a loop and sending out update requests.
Regards,Jamal
-
It is easily done with alerts & actions.
-
Please add my vote to do this also...this is one of the main reasons we got a SmartSheet Lic.
-
This functionality is presently available with triggers.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives