Auto Populate an entire column with the value of one cell from another column

Matthew Drag

I'm trying to populate an entire column with a value from one cell from another column within the same sheet. Is there a way to automate this process.

I would like the value that the arrow is pointing to populate the entire column "Project Name". I'm using the column as a helper column in the calendar app as a way to group these tasks.

Matthew Flebbe

Hello,

One way you can do this is to create a "Project" text field in the Sheet Summary

Once you have your field in the Sheet Summary add =Project# to a "Project Name" cell and convert it to a column formula by right clicking on the cell and then clicking "Convert to Column Formula.

You could also point the "Project" field in the sheet summary back to your top line cell reference or vice versa:

Hope that helps you!

Paul Newcome

Try this...

=[Project | Tasks]$1

Then dragfill it down the column.

Matthew Flebbe

Hello,

One way you can do this is to create a "Project" text field in the Sheet Summary

Once you have your field in the Sheet Summary add =Project# to a "Project Name" cell and convert it to a column formula by right clicking on the cell and then clicking "Convert to Column Formula.

You could also point the "Project" field in the sheet summary back to your top line cell reference or vice versa:

Hope that helps you!

Matthew Drag

Awesome! Thanks @Matthew Flebbe Much Appreciated