Claire Lockhart
Claire Lockhart

Reputation: 1

Inserting a condition into query with indirect function. Receving #REF error

I am querying information from a sheet named after the current month and year. The first formula works appropriately, but I need to add a condition where it only queries the rows where A is true on the dated sheet. The second formula is an idea of what I need, but I receive a #REF error. I would really appreciate any assistance with this as I have been stuck.

=QUERY(INDIRECT("'"&text(today(),"mmm yyyy")&"'!B4:Y"))

=QUERY(INDIRECT("'"&text(today(),"mmm yyyy")&"'!B4:Y where A=TRUE"))

Sheet that I need to query data from, but only when check box in col A is selected

I have tried multiple variations of this formula but have no found a format that works as desired. Always receive errors. The formula works as desired, but have not determined how to add the condition.

=QUERY(INDIRECT("'"&text(today(),"mmm yyyy")&"'!B4:Y where A=TRUE"))

Upvotes: 0

Views: 60

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 30309

Can you try:

=choosecols(QUERY(INDIRECT("'"&text(today(),"mmm yyyy")&"'!A4:Y"),"where A=TRUE"),sequence(columns(B:Y),1,2))

Upvotes: 0

Related Questions