Whats wrong in this formula since its not returning an value.
any(select(ShiftWorking[ShiftWorkingID],and([StartDate]>=[_thisrow].[Production Date],[EndDate]>=[_thisrow].[Production Date],[pressid]=[_thisrow].[press])))
Date is stores in dd/mm/yyyy format in google sheet
This part is likely the problem. This means to select a row where “Product Date is less than or = to the Start Date AND Production Date is less than or = to the End Date”.
You probably mean to select a row where “Production date is BETWEEN the Start Date and End Date”?
If so you just need to switch the Start Date operator from “>=” to “<=”
If not then please explain, in words, which rows you want to select.