Search within all multi-selected fields for duplicates
I am wondering if there is a way to detect when there are duplicates of a multi-selected item in another row.
My formula so far: =IF(OR(ISBLANK([email protected]), ISBLANK([email protected])), "", IF(COUNTIFS(Checkout:Checkout, >=([email protected] + 1), Checkin:Checkin, <=([email protected] - 1), SiteNumber:SiteNumber, [email protected]) - 1 > 0, "Double Booked"))
I am basically working towards a booking system. I want the Formula field to populate "Double Booked" when two booking's dates overlap, AND share a "SiteNumber". I have figured out the overlapping dates part, and the SiteNumber part works when the filed type is text/number, but that limits me to only allow one site number in the SiteNumber field.