I am trying to create a resource/capacity planner that allows me to play around with when team members are assigned to the project.
I want to be able to add in a number on the days they are assigned to the project (for example 0.5 for half a day, 1 for a full day).
I need the sheet to calculate the start date of a task based on the first cell that has a numerical value.
I don't know how to make the formula reference the corresponding date in the same column.
The current formula I am using is:
=IF(ISNUMBER(INDEX(E9:FE9,MATCH(TRUE,INDEX((E9:FE9<>0),0),0))),E$8, "Not Planned")
Right now, the first part of my formula manages to react to the first number in the row.
I need it to then recognize which column the first number belongs to and reference the corresponding date on row 8.
A copy of the sheet can be found here: EXAMPLE SHEET
Any help is much appreciated!