Hey everyone! Thanks so much for all the help you’ve given, I’m still learning and this community has made it a great experience!
I think what I’m trying to do can be solved with nested IF statements, just can’t seem to find the definitive answer looking through old posts. Here’s what I want to do.
I want to calculate the number of hours it takes to do a certain job for a certain employee, where each employee takes a different amount of time for that job.
For example, Employee 1 takes 4 hours to do Task 1, but Employee 2 takes 3 hours to do the same task. There are a bunch of employees and a bunch different tasks, and the hours are different for each employee. Is there a not so messy way to do this?
Thanks so much for the support!
EDIT: this is the formula that I have that works for one Employee and one task
IF(
AND(
{Employee} = “Employee 1”,
TASK = “TASK 1”
),
“4”
)
Where it will show 4 hours for Employee 1 to do task 1.
Where I get confused is how to nest a whole lot of these to cover all possible coniditions. Basically, for each employee, there could be any one of 8 tasks assigned, and the hours for each employee differ for each task.
If there is a much easier way to do this, I’m all ears!