Auto fill column with value from first cell in another column

Andrea Zenner

I have an application where I use a header row to collect higher level project information, like overall project status, project start and end dates (as opposed to task start and end dates), etc.

I copy rows from individual project plans to an "all projects" sheet from which we do some PowerBI reporting.

I need a column that has the project status in it so we can filter certain projects (on hold, complete) from our reporting. That status is set in the first cell of the Status column via a drop-down list.

I would like that entire column (or it could be another column) to auto-populate based on what is picked in that first cell. For example, if they change from On Hold to In-Progress I need the full column to change to In Progress.

I've tried creating a new column and using an =Status$1 formula, but I get an error when I try to make that a column formula.

Any ideas are appreciated!

Andrea

Andrée Starå

Hi @Andrea Zenner

I hope you're well and safe!

You could reference the cell in a sheet summary field and then reference it in the column you want to convert to a Column Formula.

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!