Hi! Is there a way to automatically add data columns to a sheet once a new row is created? For each business, I have additional columns I created to display within the app, but I have to manually type them in every time a new row is added. Thanks!

Can you share more details about what exactly you want to do?

My app is a directory of businesses.A businesses fills out a google form with their information which gets sent the master sheet. After this,I have to fill in additional columns, such as tags, roles, passwords, avatars, etc. I would like for this to automatically populate once a new row is added. …

Sure @Jen_NYCP , I do this all the time using GSheet ARRAYFORMULA. ARRAYFORMULA is used when you need to place a formula in the first cell os a column and what that formula to be repeated in every cell below. For example, if I need the content from every new cell in column B to be “New”, I can use …

Ah! Thanks! I have like 7 columns, where do I add these formulas?

[image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s …

You can add the formulas in the header as @ThinhDinh suggested or in the first content row if you already have the content for it (I use this second option but both will work just fine). BTW, amazing tutorial @ThinhDinh , I really wanted something like that when I was starting (and struggling) to us…

I already have text in the header, so I should create a blank row right under that to add the formula?

Usually I just manually add the first row (with the formulas) and the spreadsheet magic do the rest.

Fill in Columns as Rows are Added

Ask for Help

ThinhDinh September 11, 2020, 12:50am 6

You can add those in the header.

Topic		Replies	Views
Sheet formula is not working on newly created row Ask for Help	24	3592	May 31, 2020
Add row in googlesheet with the app Ask for Help actions	7	971	December 10, 2022
Script to add formula to new rows Ask for Help	10	3314	February 20, 2020
Apply an existing formula in Google Sheet when a new item is added by the user Ask for Help	6	885	November 29, 2020
Dynamic cell value not working Ask for Help	9	891	February 17, 2022

Fill in Columns as Rows are Added

Related topics