I am attempting a query where I match to any of the items in Column D "Tag" as shown below:
Currently, I have it to query only from cell D2, but any attempt I have tried to expand that to the entire list in column D have proven futile.
D may not always be the same length, so it is important that the result is not restricted on any particular cells (want D2:D).
An adjustment to your current formula using textjoin()
should do:
=query(drafts!A:C,"where A matches '"& textjoin("|",1,D2:D) &"'")