Cell range not linking between two sheets in workbook (Google spreadsheet)

0
votes

I am new to google spreadsheet functions and trying to apply formula in following way:

I have sheet1 & sheet2 in one workbook (name-formula1).

I want to link range data from sheet2 & range a1:a10 in sheet1 and cell A2, formula mentioned is as under:

=Sheet2!A1:A10

Now concern is that it is displaying only one item (last one) from the range whereby it was supposed to display ten items (a1:a10)

Please look the following link for detail and help in correcting above formula:

https://docs.google.com/spreadsheets/d/1HX1eatP57A5k9Xku7awIVnBPQ2A4ICVrYXTsTOza9Cg/edit#gid=0

1
google-apps-script

1 Answers

1
votes

You will need to wrap that in an index() or arrayformula().. So try:

=Arrayformula(Sheet2!A1:A10)