User Profile
NynkeHillen2001
Copper Contributor
Joined Jun 06, 2023
User Widgets
Recent Discussions
Formula for gannt-charts in projects
Hi everyone, I am trying to make a gannt-chart for projects and I encounter the following problem. In the picture you see at my company we have different types of projects (full, medium , light , full ctpd). Regarding this there are different types of hours involved every week, so we have made basic scheme for each type of project(see second picture). I would like that Excel returns these rows based on a) the type of project and b) that it starts returning this row from the date (week) the project starts. The conditional formatting between start date and end date is not difficult to format. Secondly return the rows is also not the problem however let the rows start from the start date is difficult. Does someone has thoughts on this?
