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
