Fill in Columns as Rows are Added

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.

Is this possible?

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 something like that on the B2 cell (assuming that B1 is the header):

=ARRAYFORMULA(IF( A2:A = “”, “”, “New”))

This will check if A2 to the last created A cell has any content, if its blank, nothing happens but if has anything, the value in B will be New for each valid row.

hope

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

1 Like

You can add those in the header.

3 Likes

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 use ARRAYFORMULA!

2 Likes

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

Oh thx!!

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

1 Like

Thank yoU!

1 Like