CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
USER-RANDOM
USER-RANDOM

Reputation: 1

How can I create a QR code for multiple cells in Google Sheets?

I am trying to create a QR code for multiple values in a column. I searched and found that the below formula lets me create a QR Code for a value in cell A1:

=IMAGE("https://chart.googleapis.com/chart?chs=500x500&cht=qr&chl="&A1&"")

Trying to expand it into 2 values I tried:

=IMAGE("https://chart.googleapis.com/chart?chs=500x500&cht=qr&chl="&A1&"%0A"&A2&"")

But the result of scanning the QR was just a the 2 cells combined. (ex: 404832221400252221)

What I am trying to get is a QR code that will output the entire column of data cell by cell. Something like this:

404832221

400252221

...

...

Is this possible?

Upvotes: 0

Views: 1774

Answers (2)

Utkarsh Agrawal
Utkarsh Agrawal

Reputation: 1

Not sure how to arrange the data in different rows, but the below formula will add space after every data.

=HYPERLINK("https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl="&A1&" "&A2&" "&A3&" "&A4,"QR CODE")

Upvotes: 0

player0
player0

Reputation: 1

use this:

=INDEX(IMAGE("https://chart.googleapis.com/chart?chs=500x500&cht=qr&chl="&A1:A))

enter image description here

update:

=INDEX(IMAGE("https://chart.googleapis.com/chart?chs=500x500&cht=qr&chl="&
 QUERY(A1:A10;;9^9)))

Upvotes: 0

Related Questions