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

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    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.

  • dojones
    dojones ✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!