Can I auto populate values in a coumn?

Agata Wozniak

Hi,

I have 10 sheets built in the same way: pre filled with many information. Each sheet will be used by many team members. But I need the team to be able to add rows in that sheet.

I have 4 columns that I would like to keep locked. What happens now is when a row is added the Complexity & Country column stay empty - which ruins reporting.

My question is: is there a way to make sure that each new row is auto populated with Country name & Complexity?

Thanks in advance!

Andrée Starå

Hi @Agata Wozniak

I hope you're well and safe!

Yes, either by copying a current row, using formulas so it auto-fills, or by using a Workflow that adds the value after a new row has been added.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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

Agata Wozniak

Hi,

yes this is great. Thank you!

Andrée Starå

@Agata Wozniak

Excellent!

Happy to help!

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