Hello!

I am trying to create a list for “project allocations”. So I have a table with all or staff members in column A and in row 1 all our projects. In the cells in between, if a staff member is assigned to a projects there is a value for their time invest in this project, e.g.

In another sheet, I want to list all projects and underneath each project list all staff members that are assigned to this client, e.g. spend time on it, so where there is a value for them in the client column in sheet 1.

Long term I want to add more about functions etc., but I am already struggeling with the first one. I tried “filter” and also if project column is <>” ” but if it does anything at all it always just returns everyone in the staff list.

Does anyone have any idea what function would work best? Thank you!

​Hello!I am trying to create a list for “project allocations”. So I have a table with all or staff members in column A and in row 1 all our projects. In the cells in between, if a staff member is assigned to a projects there is a value for their time invest in this project, e.g.In another sheet, I want to list all projects and underneath each project list all staff members that are assigned to this client, e.g. spend time on it, so where there is a value for them in the client column in sheet 1. Long term I want to add more about functions etc., but I am already struggeling with the first one. I tried “filter” and also if project column is <>” ” but if it does anything at all it always just returns everyone in the staff list. Does anyone have any idea what function would work best? Thank you!      Read More

​