Request an Update Automation - specific rows
I have a form that asks for three names separately. Three different roles.
The last question on the form asks, “Request an Update”. Defaults yes
The worksheet has three columns to match the name/role.
Column properties set as “contact list”
Automation uses “Request an Update”
· Trigger: When rows are changed AND when 'role1 E-Mail' changes to Any Value, or when 'role2 E-mail' changes to Any Value, or when 'role3 E-mail' changes to Any Value
· Actions: Request an update
· Recipients: Contacts in 'role1 E-Mail', Contacts in role2 E-mail', Contacts in role3 E-mail'
Question: With every new form submitted (new order) with either same, mostly same, or different names is the “Request an Update” only specific to that row?
What I am hoping to accomplish is that the original submission generates a “Request an update” back to three named individuals to submit a 2nd or, if need be, a 3rd time if any additions/changes are needed. But again, it must stay specific to that row only.
Will I get the outcome I am hoping for with what I described above?
Thanks
Answers
-
Hi @DanielGD
I hope you're well and safe!
Not sure I follow!
Can you elaborate on the Roles and when they should be able to update?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives