droeyourhero
New Member
Hi Everyone!
I'm looking for help/suggestions for the following issue:
I'm trying to develop a spreadsheet to track equipment utilization and to either flag or prevent the selection of a piece of equipment that is over utilized based on an overlap in the time period. In the sample that I've provided I have a simple list of projects with start and end dates then I have a column for equipment ID and a column for the description of that corresponding piece of equipment.
The first three columns are conditionally formatted to highlight overlapping dates. The forth column is a simple drop-down list, and the fifth column is supposed to return either the equipment description if the piece of equipment has not been used on another project, or return "overallocated" if it has been chosen to be used on a project that has a time overlap with another project.
On the attached spreadsheet Projects 18010 and 18040 have Start and End dates that overlap. I chose Equipment C-100 for both and it returned "overallocated" as it was supposed to. But then I chose the same piece of equipment for Project 18020, which has a Start and End date that does not overlap with any of the other projects, and should allow me to choose Equipment C-100, but still returns "overallocated". This is where I'm stuck at.
Any help would be greatly appreciated.
I'm looking for help/suggestions for the following issue:
I'm trying to develop a spreadsheet to track equipment utilization and to either flag or prevent the selection of a piece of equipment that is over utilized based on an overlap in the time period. In the sample that I've provided I have a simple list of projects with start and end dates then I have a column for equipment ID and a column for the description of that corresponding piece of equipment.
The first three columns are conditionally formatted to highlight overlapping dates. The forth column is a simple drop-down list, and the fifth column is supposed to return either the equipment description if the piece of equipment has not been used on another project, or return "overallocated" if it has been chosen to be used on a project that has a time overlap with another project.
On the attached spreadsheet Projects 18010 and 18040 have Start and End dates that overlap. I chose Equipment C-100 for both and it returned "overallocated" as it was supposed to. But then I chose the same piece of equipment for Project 18020, which has a Start and End date that does not overlap with any of the other projects, and should allow me to choose Equipment C-100, but still returns "overallocated". This is where I'm stuck at.
Any help would be greatly appreciated.