Auto Populate Column Data

MSGFreebird

I have a sheet that I am populating row one with data inputted using an intake form (Form1). I then have a Update form (Form2) that is used by end users to input additional data.

I need the data inputted from form1 to auto populate the entire column the data resides in when form2 is submitted.

Any suggestions on how to accomplish this since I cannot apply cell formula to a column?

Paul Newcome

Yes. The "@row" piece of the formula is looking for the cell within the row of the formula. So on any row where the meta columns are blank, "@row" will also return blank.

Try this instead:

=INDEX([AT-Meta]:[AT-Meta], 1)

Paul Newcome

So the end user would fill out an update request for row 1 and then you would want that same data to be populated down the rest of each column?

How far down does it need to go? Are you able to provide more details regarding the overall workflow?

MSGFreebird

Howdy Paul;

Form1 is completed by the scheduler. Form2 by the end user.

The scheduler inputs the specific contact(s) in the form for each cell in row1. Then the end user inputs data that populates different columns in the sheet.

I need the columns with data inputted by form1 to populate the same column cells for each row added when a form2 is submitted.

Does this help?

Paul Newcome

It looks like you are already using column formulas. What do you currently have in there?

MSGFreebird

The four columns currently using Column formula is puling from the first 4 cells of row1. The formula is fx=[EN-Meta]@row.

if you look at the second screenshot I sent, you will see that no data was populated from the column formula for the added rows

The issue I believe is the column formula is looking to populate with cell data from the added row, cell1.

Paul Newcome

Yes. The "@row" piece of the formula is looking for the cell within the row of the formula. So on any row where the meta columns are blank, "@row" will also return blank.

Try this instead:

=INDEX([AT-Meta]:[AT-Meta], 1)

MSGFreebird

Thank you Paul, that fixed my problem.

Paul Newcome

Happy to help. 👍️