Home > Mobile >  How can I produce a value while querying data from a range in Google Sheets?
How can I produce a value while querying data from a range in Google Sheets?

Time:10-26

How can I have the first column automatically populated with specific values on each query of the formula?

This is the formula I had started with: ={"COGS",query(Sheet30!A2:D,"select * ")}, thinking that COGS would be in the rows below, but if I have more than one row in the range POs!J2:V, it already throws an error.

This is how it should look like: enter image description here

enter image description here

  • Related