Force upper case on a column

Force upper case on a column

Juan-JLCJuan-JLC
edited 02/28/20 in Formulas and Functions

Hello Everyone,

I got a question.

Is there any way to force upper case on a text column?

I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font in it.

Thanks

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 02/28/20

    Hi Juan,

    You’d need to use a so-called helper column and the UPPER function.

    More info.

    Would that work?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hey Andree,

    I looked into it but that means I have to have a column for input and another for view, which is a bit of a pain.

    I am looking for more of a setting where I can set the column to always be upper case.

    I mean, a formula will be good as well, as long as it affects the cell I am inputting the info into it.

    Thanks

    @Andrée Starå

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    The third-party service, Zapier, is an excellent option. Is that an option for you?

    Another option could be the Smartsheet API.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Juan-JLCJuan-JLC
    edited 03/02/20

    Hi Andree,

    I have been trying to work with Zapier but I have not been able to get it to work (Do the uppercase on update).

    I must be doing something wrong. @Andrée Starå

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Have a look here.

    Did you get it working?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.