Select Entire Coloumn in Sheet Summary Formula

Brandon Bear

This might seem super basic, but I am trying to build a formula in a sheet summary and want to define an entire column as the rane. I know that it should look like [Column Name]:[Column Name] but is there any way to select the whole column to automatically insert that synax into the formula without having to type it out?

Andrée Starå

Hi @Brandon Bear

I hope you're well and safe!

Unfortunately, it's not possible now to select the entire column, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Brandon Bear

If it helps, you can click on one cell in the column to automatically populate the column name once (with a row reference to indicate where the cell is located).

Ex: [Column Name]7

All you have to do then is delete the row reference number, add the colon, then click on another cell to populate the name again (and remove the row reference again).

See: Create a Cell or Column Reference in a Formula

Cheers,

Genevieve

Andrée Starå

@Genevieve P

Excellent tip!

I assumed that OP would know about that feature.