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


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.

Best Answer

  • Matthew Flebbe
    Matthew Flebbe ✭✭✭✭
    Answer ✓


    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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!