Date range and duplicate values
We are trying to use Smartsheet to manage our engineers. At the moment, an engineer can only be on one project at a time. Is there a way to search a Start and Finish column and see if an engineer's initials appear twice anywhere within that Start and Finish range? I've attached a screenshot of how it looks currently:
(Apologies, I've removed the client from here so the titles may look a bit odd!)
What we want to do is easily see if an engineer is double booked across any date range. At the moment, we have up to 8 columns where that engineer's name could appear (Eng1 - Eng8 respectively).
Any help would be much appreciated! Thanks,
Help Article Resources
Check out the Formula Handbook template!