Copy the cell above every time a new row is added

Connie Cochran

I have some hidden columns that I want to auto populate when a new line is added.

I tried =([Client Name])@row but was getting an error

Help?

Carson Penticuff

Try removing the parentheses.

=[Client Name]@row

Connie Cochran

Tried that too and got an error saying #circular reference

Carson Penticuff

Are you attempting to copy a cell from the new row or from the previous row?

Paul Newcome

Are you able to provide some screenshots for context (sample data is fine if needed).

Connie Cochran

the first 3 columns will have information in the first cell and hidden when I publish the form. I would like those columns to auto populate with the same information every time that information is added in the "Employer Name" column.

Paul Newcome

If you are using a form to collect new rows, you can set them as default values in the form and then make sure those fields are hidden.

If you are collecting new rows directly in the sheet, you would use a column formula such as

="Suzies Bakery"

Connie Cochran

I'm using a sheet but how does it update to the next row without manual intervention? Is there a way to write a formula that says if employer field is not blank then return information in client name@row?

Paul Newcome

Try the above. Just put

="Suzies Bakery"

into the Client Name column and set it as a column formula.

Connie Cochran

Great! Seemed to simple but it worked

Paul Newcome

Happy to help. 👍️

Technically that is a formula. It starts with "=" and has some sort of output. We just didn't need anything too crazy for this one.