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.



  • 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.