Add project name to update requests
I have numerous projects that all have the same work breakdown structure. If I send out request updates (via automation) the end user doesn't know which project the request is asking about. Unless I specifically state what project I am referring to in a manual update request I don't see a way to have that info included. So to the end user, all context is lost about what project. Is there any way to have that included in all my automated update requests? Thanks for any help provided.
Answers
-
Great question, and this is something we have run into with our project management solution. Do you have the project name/number included in your sheet name? That would be my first suggestion, since the sheet name should be listed in the update request.
Do you use Control Center to spin up projects? If so, I suggest adding a column to your sheet for project number/name, and cell linking that to pull from your metadata sheet. You could then include that column in your update request.
Julie Fortney
julie.fortney@swc.net
-
Hi @edb309
I hope you're well and safe!
To add to Julie's excellent advice/answer.
- Another option that I often use in my solution is to add a Sheet Summary Field with the Project Name, then reference it in a so-called helper column, and make it a column formula so it will be included on all rows. You could then have that column in the Update Request.
Make sense?
Would that work/help?
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, Awesome, 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.
-
Hello,
I don't use Control Center, however I am exploring the possibility to add the project name to the Send Update Request to don't have to type it for each of the projects and Project managers, since a project manager could have multiple projects. Thank you
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives