Auto fill a cell when a new row is added

jeflanne

How do I auto populate a column when a new row is added?

Paul Newcome

As long as there are at least two rows above and/or below the new row that have the formula(s) as well as the same hierarchy, autofill should work.

cfavron103911

I would like each new row to autofill one column with the same formula as the row above it. I am unsure where to find the command or formula to insert the 'autofill' instructions? Can you point me in the right direction?

Andrée Starå

Hi @cfavron103911

Not sure i follow!

Doesn't it work for you when there are two rows before/after?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

It should work automatically. There is no specific command, function, or formula.

Paul Newcome

@alecching Are you able to expand on that or provide some mocked up screenshots for reference?