Simple UPPER formula with Circular Error
I am using =UPPER([License Plate Number]@row) to capitalize all data entered into a specific column, and it keeps returning circular reference. Don't know what to do. This is for license plate information.
If I enter the formula into a column that is not the license plate column, it just moves the license plate info on that row into whatever column i put the formula in.
Any thoughts?
Answers
-
It looks fine to me. The only way I could see this throwing an error would be if you were attempting to put the formula into the License Plate Number column.
-
I think you need to change the way you are looking at it. Consider the main field to be License Plate which contains the formula UPPER([License Plate Entry]@row). All other references should be to License Plate which would by the Upper case version of License Plate Entry. License Plate Entry is where the initial entry goes, but it is basically a helper field.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!