Multiple contacts on a line item, breaking it out
I am at a loss on how to structure this, maybe somebody has some ideas.
I have a list of Projects - 300+
Each project can have multiple people assigned to it, these people may change over time
The team now wants to track resourcing, by week.
So for a given week they want to say person A is working so many hours on project 1, and so many on project 2
I am trying to figure out how to surface a view (and record the data each week) for a particular person, showing projects their names are on, and hours spent. So somehow I have to be able to record multiple time entries per project if there are multiple people assigned.
Note, we are no using any add on modules, just basic Smartsheet.
Thanks
Answers
-
Hey @David Dolch -
Can you clarify a little bit more on your situation or even provide a quick screenshot of an example (removing any sensitive data of course) - that would help me understand the situation a little better.
Also - if multiple people are assigned to the same project - are they recording their hours spent in separate columns?
There may be a number of options to work around this issue.
Hope I can help!
-Jon Mark H.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives