UPPER formulas

tcanelli41471
tcanelli41471 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

  • Taylor F
    Taylor F Employee

    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

  • SaulB
    SaulB ✭✭

    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...

    Job_Application_Form_-_Smartsheet_com.png


    Job_Application_Form_-_Smartsheet_com.png


  • Andrée Starå
    Andrée Starå Community Champion

    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 EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • SSFeatures
    SSFeatures ✭✭✭✭✭✭

    Hi @SaulB, @tcanelli41471, my name is Nathan and I'm building a browser extension that improves Smartsheet.

    The browser extension is SSFeatures ( https://ssfeatures.com ) and you can use it to enforce different capitalization rules on all of your data.

    image.png

    It currently supports the following capitalization rules:

    • Uppercase: "THIS IS AN EXAMPLE"
    • Lowercase: "this is an example"
    • Title Case: "This is an Example"
    • First Letter Upper Case: "This Is An Example"
    • Sentence Case: "This is an example"

    You can use this to enforce rules on your data without needing to use a helper column, even if the data comes from a form.

    Hope this helps!

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)

    SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!