When added to a project, automatically add project to team member project page
I am a newbie with this, so hopefully I make sense.
What we are trying to do is when we add someone to a project, that they will have the project added automatically to their personal project page where they can keep track of their hours spent on the project.
Ideally we would like to see the total hours for each project get fed back to the sheet that keeps track of all the projects.
I have included 2 screen shots of the basic layout.
I was able to add the person to their sheet, but I had to use a helper column, which was hidden, it was very clumsy and did not work well.
Any help would be appreciated.
Thanks.
Answers
-
Hi @horace West
I'd recommend using a report instead for the members to see their assigned tasks.
Would that work?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!