I'm trying to use the UPPER formula for a column input, in my case the column name is "Client" and I want the user to enter the client's name as an uppercased string

this is what it shows after entering either a lower or uppercased string and clicking save

I tried: =UPPER(Client) and =Client=UPPER(Client)in the formula box and none worked


Try to use the below formula


enter image description here


enter image description here

Other Workaround,

  • Remove the current validation formula,
  • Try to create a new calculated field with the below formula

    =UPPER([the column name])

Then use the newly calculated column as per view purposes like "All Items, Display" pages

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.