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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!