1

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

2

Try to use the below formula

=NOT(ISERROR(FIND(UPPER(Title),Title)))

enter image description here

[Output]

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

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.