Absolute Reference

alfred

Hello, I created a column and am trying to have text from a cell always populate in all the cells with in the that column. Also when a row is added the text will populate in that new cell. I tried the convert to column formula but that brings in all the names from the column that that cell is in. I hope that makes sense. - Thank you

Paul Newcome

Column formulas cannot use absolute references or specific row numbers. You can reference a sheet summary field as a column formula though, so you could create a sheet summary field that is

=[Property Address]10

Then use a column formula to reference that field.

=[Sheet Summary Field Name]#

Peggy Parchert

Hello @alfred

This is a good article on absolute reference:

Create a Cell or Column Reference in a Formula

Hope it helps

Peggy

Paul Newcome

Are you able to provide screenshots for reference?

alfred

Cell Reference.bmp

Uploaded Mar 28, 2023149.96 KB

Cell Reference2.bmp

Uploaded Mar 28, 20231.93 MB

Hello, the column that the formula is in will not allow me to convert to column formula. I receive an error that the syntax isn't quite right. The idea is that I would like the Relationship Manager column will always be John Doe.

Thank you,

alfred

Paul Newcome

Column formulas cannot use absolute references or specific row numbers. You can reference a sheet summary field as a column formula though, so you could create a sheet summary field that is

=[Property Address]10

Then use a column formula to reference that field.

=[Sheet Summary Field Name]#

alfred

Thanks Paul this does help.

Paul Newcome

Happy to help. 👍️