How do I copy a formula from one cell in a row to all the cells below it in that Column

SCC713 · 11/07/22

How do I copy a formula from one cell in a row to all the cells below it in that column?

If a cell has a check box in it, I am looking for it to be checked if a corresponding cell is checked.

I would like to take that formula populated all corresponding rows below it follow that formula.

Is there also a way to copy all the formatting of that column to another column?

Andrée Starå · 11/07/22

Hi @SCC713

I hope you're well and safe!

Have you explored using a Column Formula?

Would that work/help?

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

SCC713 · 11/07/22

https://community.smartsheet.com/discussion/comment/350206#Comment_350206

This worked. Now how to copy that formula to other columns?

Andrée Starå · 11/07/22

@SCC713

Excellent!

What do you mean by the other columns?

✅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!

SCC713 · 11/08/22

I fI have 5 columns of information, and one column with a column formulas, I wouldn't want to have to create a new formula for each column.

We are writing of Grid view.

Andrée Starå · 11/08/22

@SCC713

Ok. If you want to include more columns, you'd have to add the column formula to each column (or include multiple columns in the range), unfortunately.

✅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!

How do I copy a formula from one cell in a row to all the cells below it in that Column

Answers

Help Article Resources

Categories