i.e. a table with multiple projects, each project has multiple tasks. All tasks are assigned to a team of a few engineers, and have a start and end date…
I’d like an easy way to know if any engineer is allocated over a 100% on any given day… A simple way is to see if there are more than one tasks assigned to a single engineer on any day… If so I’d like to do a conditional formatting on the tasks or engineer… is this a solved problem?