Yes! That did it! I know I can like your post but can I give you a badge or something? 
Iāve been beating my head against the wall on this one! Iām finding the trouble comes when I know enough to figure out what formula or action I need but not enough to know whatās wrong about it when Iām looking at it.
Thank you so much!
Iāve been there. 
Know enough to be dangerous, or know exactly what you need or want, but not exactly how to do it.
Hahaha dangerous is right 
Are you aware that you could start an arrayformula in the header row using this trick?
={"YourHeaderHere";ARRAYFORMULA(Sheet1!A2:Z)}
Note: Donāt forget the } at the end of the formula
Even better!? Donāt know this trick. Wow.
What do I have to change in the script to make the formulas of 3 different rows in the same sheet autofill?
What type of formula are you trying to autofill?
I actually think I figured it out! thanks you!
Hi there! Wondering if there is a way to insert through the āUser input formā multiple options.
i.e Jack is the User & selects multiple fruits to buy.
Thus the data in GSheets should appear as Column A: Userās Name & Column B: List of Fruits.
Within Glide, how can Jack select "Bananas, Oranges, and more from the option set in order to have it populate into GSheets as a list (Apple, Pear, Banana, etc.)
Iāve been searching the forum but I feel Iām doing a newbie thing. 
This concept app does exactly that (and more)ā¦
Sorry, did not understand how to use arrayformula to count the exact number of True in several columns. I wrote the numbers I expect in red square.
What layout do you expect? Do you want a checklist or do you want something like what Darren did in the link he provided?
Either way, the idea is to use a relation and have a joined list column linking all the items chosen together, then write them to the Sheet using a set column action.
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,
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.
Glad it could have helped!
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.
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/
If you still need me to help with this, please share your Sheet to ariesarsenal@gmail.com.
