How to keep track on project managers who leave the company in assigned to columns (losing SS accoun
Hi all,
A new day, a new question.
We are currently keeping a database in which we track every market research project we are running or ever run in the past. The project manager is entered in an 'assigned to' column. So for example in 3 years time we still know who managed a specific project.
However, if the PM is no longer active in the company --> the SS account will disappear --> the contact will disappear in the 'assigned to' column.
How can we keep track on PMs that have left the company. Just so we know in the future who has run a specific project?
Thanks,
Jef
Answers
-
Hi @Jef Snyders
We can do this with multiple ways to keep a track of specfic role based members:
1) In your main project database, instead of directly assigning project managers to projects in a static column, use a dropdown list or cell linking to link project managers from the project managers database to the projects.
With this way even if a project manager's account is deleted, their name will remain linked to the project
2) Create a separate column in your project database to capture the historical project manager for each project.
This column can be labeled 'Previous Project Manager' or similar to it1-1
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
Huma
Community Leader
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives