UPPER formulas

tcanelli41471tcanelli41471 ✭✭✭✭
edited 12/09/19 in Formulas and Functions
03/22/18 Edited 12/09/19

Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?

Comments

  • Hello,

    If you are looking to convert user entries to uppercase in the existing cell, there isn't a way to do this. 

    The UPPER() function can convert text from one cell to all uppercase. https://help.smartsheet.com/function/upper.

    Taylor

  • Tried working around this using a helper column with =UPPER([column name]@row) on automation workflows... but when triggered it ads a single ' at the start of the formula...



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

    Hi @SaulB

    I hope you're well and safe!

    Unfortunately, it's not possible to add formulas with the change cell action, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    Here's a possible workaround or workarounds

    • Add the formula as a Column Formula.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.