Smartsheet Project Management, gaant chart, resource allocation

Hello, I have an Excel spreadsheet with 50 projects, multiple resources that I need to convert to smartsheet.

Do I need to create one smartsheet for each project? I will be needing the following data from the sheets:

Gantt Chart

Resource utilization - Can I assign more than 1 resource and still get tracking info?

Milestone scheduling/Dependencies

Dashboard: Functional Team, How many projects, Status,

In addition, I will need the project owners to update their hours weekly, can they do this in one place, vs going to each project?

Thanks!

Kate

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Kate,

    Is it one project per tab, or are all projects in one?

    Do I need to create one smartsheet for each project? It depends!

    Resource utilization - Can I assign more than 1 resource and still get tracking info? Not on one row, but you can add multiple rows for the same task to make it work.

    In addition, I will need the project owners to update their hours weekly, can they do this in one place, vs going to each project? Yes, on a report.

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

    I hope that helps!

    Have a fantastic week & Happy Holidays!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.