Smartsheet Project Management, gaant chart, resource allocation

klizotte

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

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