Forum Discussion
Help With Formula
Pls see attached file.
I don't know if this is what you wanted.
see if you can work something out of it.
thanks..
Pls see attached file.
I don't know if this is what you wanted.
see if you can work something out of it.
thanks..
I spoke a little too soon. It looks like if you select a piece of equipment for two overlapping projects then it leaves the equipment column blank, which is what I want it to do, but if you select the same piece of equipment for two projects where the dates do not overlap, it still does this. I would like for it to allow me to select the same piece of equipment for multiple projects as long as the dates do not overlap.
I'll try to decipher the formula to see if I can make the adjustments.
Thanks again for the help!
hope you can work it out...
if not, try reposting it.. someone here in the forum may provide a solution.
thanks..
I think I've got it.
I changed $D$3>$C3:$C9 to $D3>=$C$3:$C$9
It seems to be working the way I envisioned it right now. I can now select the same piece of equipment for multiple projects. If the projects dates are not overlapping then it will allow the same piece of equipment. If the dates overlap then I get an "overallocation" flag letting me know to either change the dates or select a different piece of equipment.
Thanks again for your help!
This is great, when the user has dates that overlap and tries to select the same piece of equipment for the overlapping projects it leaves the equipment cell blank forcing the user to either select a different piece of equipment or to change the usage dates. Thank you so much.
