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

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭

    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.