Absolute Reference

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
Best Answer
-
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]#
Answers
-
Hello @alfred
This is a good article on absolute reference:
Create a Cell or Column Reference in a Formula
Hope it helps
Peggy
-
-
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
-
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]#
-
Thanks Paul this does help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 466 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!