Man hours & working out hours worked for a specific employee

greenlilly

Hey everyone,

I'm new to this. Here's my sheet for reference.

https://app.smartsheet.com/sheets/H5CQ6ffqh3x28mf265WJQqP5jqxvcjfHGFjcxHJ1?view=gantt

Two things.

1. I want to have a man hours column that works out how many people are in the assigned to column (I've used people's initials) and multiplies that by the duration column i.e. if there are 3 people working on 07/06, i want to multiply that by 1d (duration column) to equal 24 man hours.

2. I want to work out how many days the casual workers have worked. Their initials are CF and OB. How's best to do that? So how to run a count function in the 'assigned to' column.

Thank you!

Lilly

Andrée Starå

Hi Lilly,

I'd be happy to take a look. I've requested access to the sheet.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Hi Lilly,

 

I too have requested access. I am interested to see Andree's solution and think that I may also have a solution myself.

Andrée Starå

Hi Lilly,

Great, that we got it working!

Let me know if I can help with anything else!

Best,

Andrée