'Dynamic dropdown returns #REF in google sheets
I am creating a dynamic dropdown that returns a list of Job Orders Number that have not been completed using a =filter() formula but when using Data Validation to reference this list, it returns a #REF! as seen in the image.

I have put a sample here. Where the dropdown and list of reference is found in the tab "Work Order" and the list of reference is based on the uncompleted orders found in "Order Request".

Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
