### Author:  [@bradsigep](https://community.glideapps.com/u/bradsigep)
#### Post date: [April 6, 2021, 5:49pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/106 "2021-04-06T17:49:44Z")
Ok I will try that strategy then. What I was expecting is for the User to fill out a form and can select multiple options at once from a list.
i.e. Food Cuisines App
Options: “French, Chinese, American, Peruvian”
User Selects : “French, Peruvian” as their 2 options
Then question is followed by Favorite Areas To Eat
Options: “Houston, Scottsdale, Salem”
User Selects: “Houston, Scottsdale” as their options
Then Google Sheet holds
User’s Name
Users Food Cuisine
Users Favorite Places to Eat.
Not sure how to do it so that the User isn’t selecting from separate dropdowns each time in order to create a list ☹
Best,
---
### Author:  [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [April 6, 2021, 7:35pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/107 "2021-04-06T19:35:02Z")
Holal @bradsigep,
This post mught give you an idea of how to do it. [Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211)
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 6, 2021, 11:16pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/108 "2021-04-06T23:16:10Z")
Do you really need that info in the Sheet? Not saying that it can’t be done, but it would be easy if you don’t require that. You can store those boolean values in user-specific columns and give users a checklist layout.
---
### Author:  [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [April 16, 2021, 12:36am UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/109 "2021-04-16T00:36:35Z")
Thanks for this tutorial @ThinhDinh, I just used it on a project and it worked flawlessly 👍 👍
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 16, 2021, 3:05am UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/110 "2021-04-16T03:05:12Z")
Glad it could have helped!
---
### Author:  [@Cold\_Avenue](https://community.glideapps.com/u/Cold_Avenue)
#### Post date: [May 31, 2021, 8:42pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/111 "2021-05-31T20:42:55Z")
Do I need a glide account to make it run?
Where do I need to paste the =fillFormula() function?
I renamed the script to my sheetsname, adjusted the range to my specific range, but it didn’t work. I would apreciate it a lot, if some could make a youtube video on how to use this script to make a stocks tickers symbol list dynamic to e.g. the stocks last price when new tickers are added.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 31, 2021, 11:05pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/112 "2021-05-31T23:05:28Z")
No, you don’t need a Glide account to make those scripts run.
Here’s a walkthrough from Ben Collins: [https://www.benlcollins.com/apps-script/google-apps-script-beginner-guide/](https://www.benlcollins.com/apps-script/google-apps-script-beginner-guide/)
If you still need me to help with this, please share your Sheet to [ariesarsenal@gmail.com](mailto:ariesarsenal@gmail.com).
---
### Author:  [@profxeni](https://community.glideapps.com/u/profxeni)
#### Post date: [June 13, 2022, 1:17pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/113 "2022-06-13T13:17:24Z")
Hi @ThinhDinh ,
I just now discovered your tutorial which was what I needed. As usual well done, with lots of examples, but is something missing in my Google Sheet? For example I can’t find in edit the whole section about triggers. Also, it gives me this error: The matrix result was not expanded because it would have overwritten the data in D1?? ☹
I am trying to split a geolocation (ex: 45.995211,12.86631) into two columns (lat/lon), using the SPLIT formula and adding the ARRAYFORMULA:
={“Lat”,ARRAYFORMULA(INDEX(SPLIT(A2:A,","),1))}
={“Lon”,ARRAYFORMULA(INDEX(SPLIT(A2:A,","),2))}
Where am I wrong? Thanks as always
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 13, 2022, 1:39pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/114 "2022-06-13T13:39:02Z")
> [@profxeni](#):
>
> The matrix result was not expanded because it would have overwritten the data in D1??
In there anything in cell D1?
Arrayformulas will not expand if it means over writing existing data.
> [@profxeni](#):
>
> I am trying to split a geolocation (ex: 45.995211,12.86631) into two columns (lat/lon), using the SPLIT formula and adding the ARRAYFORMULA:
> ={“Lat”,ARRAYFORMULA(INDEX(SPLIT(A2:A,“,”),1))}
> ={“Lon”,ARRAYFORMULA(INDEX(SPLIT(A2:A,“,”),2))}
Do you actually need this in the Google Sheet?
If not, you’ll find it much easier with a simple Split Text column in your Glide Table. You could then use a couple of Single Value columns to address each of the Lat/Long values.
---
### Author:  [@profxeni](https://community.glideapps.com/u/profxeni)
#### Post date: [June 13, 2022, 1:45pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/115 "2022-06-13T13:45:19Z")
YES I need it because in the same sheet I use Google Maps functions and if I do it inside glide with calculated columns, they would not show up in Google Sheet.
Yes in D1 I have a column, as well as in the adjacent ones. Using ARRAYFORMULA should I leave the columns to the right free?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 13, 2022, 11:15pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/116 "2022-06-13T23:15:43Z")
It looks like the comma after “Lat” and “Lon” should be a semicolon instead.
I’m not sure if INDEX works with arrayformula, if it doesn’t work the right way please tell me.
---
### Author:  [@IDEApps](https://community.glideapps.com/u/IDEApps)
#### Post date: [September 8, 2022, 2:49pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/117 "2022-09-08T14:49:18Z")
Hi @ThinhDinh…
I use arrayformula as follows: **=ARRAYFORMULA(IF(ISBLANK(AE2:AE),“”,AE2:AE+AR2:AR+BE2:BE))** on cell BK2. Then, I format BK column with the number formula: Rp1,000 as image below. But, when I insert/input a new row, the number format doesn’t work to a new number (cell BK5). And, I have to reformat the numbers manually 🙃
Do you know how to solve this problem?
Thanks in advance
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 8, 2022, 3:49pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/118 "2022-09-08T15:49:55Z")
Is there any particular reason you are not use a math column in glide to calculate that result, and then formatting it within glide?
---
### Author:  [@IDEApps](https://community.glideapps.com/u/IDEApps)
#### Post date: [September 8, 2022, 11:55pm UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/119 "2022-09-08T23:55:34Z")
Because the numbers are related to its Google app script. I can’t use a math column for GAS. Do you have any suggestion @Jeff_Hager?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 9, 2022, 12:07am UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/120 "2022-09-09T00:07:55Z")
Do you need it to be a number? If you can live with it being a text, I think you can just add “Rp” to the formula before you calculate it.
```auto
=ARRAYFORMULA(IF(ISBLANK(AE2:AE),“”,"Rp"&AE2:AE+AR2:AR+BE2:BE))
```
---
### Author:  [@IDEApps](https://community.glideapps.com/u/IDEApps)
#### Post date: [September 9, 2022, 12:20am UTC](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/121 "2022-09-09T00:20:04Z")
Yes, I need it to be a number. Is it possible?
[Previous page](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727.md?page=5)
[Next page](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727.md?page=7)