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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives