Automatically request updates weekly without a trigger event
We have created a new Smartsheet for our quarterly goals including an Assigned To, Status and % Complete fields. We would like to have an Update Request send out automatically at 8 am every Monday morning asking for people to update their Status and % Complete fields every week.
I tried going in and creating a new Update Request, but it requires me to identify a trigger event "When the following changes occur". The problem is, nothing should really be changing to trigger on, we just want the Update Request to be sent out automatically, even if no-one has made any changes since last week.
How can I setup my Update Requests to be sent out automatically each week to the Assigned To contact, even if there aren't any changes to trigger the event?
Or is there some type of trigger event / change setup that I can setup that will work?
Thanks! :-)
Comments
-
You have to: (See Screenshot)
- Click on the down arrow next to a row you want to send an update request on.
- Choose Send Update Request
- Choose Delivery Settings
- Adjust frequency,
- Set day
- Set time.
Wash, Rinse, Repeat for each row.
-
Thanks @Mike Wilday. This technically does what I'm looking for, although it would be tedious to manually setup a personal update request for each goal (record row) on the sheet.
Does anyone know if there is a way to bulk request updates for all rows that are assigned to a specific user?
I seem to vaguely remember doing something like this a few years back. -
UPDATE: I found a way to Request Updates in bulk weekly:
- Click the row number at the top of the bulk set of rows.
- While holding the shift key, click the row number at the bottom of the bulk set of rows to select the full bulk data set.
- Right click on the row number for one of the rows selected.
- Click on the Send Update Request... menu option link.
- Enter the recipient, subject and message as desired.
- Click on the [Edit...] button next to the Delivery option.
- Change the frequency to Weekly.
- Change the Deliver On date and time.
- Click the [OK] button.
This will send a single email that will show a summary of all of the selected rows. Clicking on the [Open Update Form] link on the email will bring up a form to update the first row with an option at the bottom to move to and update the next row (paginated forms).
-
Wow. Great find and quick and easy to accomplish!
-
I am looking to do something similar, however, I want to ensure that we only ask for updates for active / open items. Is there a way to set a condition for what rows you want the update on weekly?
-
Hi!
In reference to your original post - We are going to be creating a similar sheet and implementing a process to get updates made on that sheet by managers. We are relatively new at Smartsheet and wonder if you'd be willing to share a blank copy of the sheet with us so I could take a look and potentially not have to re-invent the wheel?
Thanks Much!
Kit
-
Hi Kit,
Did you get something set up?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello,
Related to this topic, I am wondering how can I add a conditional. I am trying to send out a monthly update request to different users but they should be updating only the current month which is only one column.
If can explain myself better this is what I am trying to accomplish:
My rows are my items
My columns are my months
I need to ask different users to update different rows (one user can update more than one row) every month. Fill out the data correspondent to previous month.
I appreciate any help
Silvia
-
Hi Silvia,
The simplest method I can think of would be to lock the month columns except for the current one. The users would be able to see all of them, but they can only update the current one.
Would that work?
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you Andrée,
I will try that.
You too, have a great weekend!
-
Excellent!
Happy to help!
Let me know how it goes!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives