nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

UPPER formulas

tcanelli41471

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?

Find more posts tagged with

Forms

Sheets

Formulas

Solution Center

Comments

Taylor F

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

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å

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!

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.

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!

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIFS formula bringing back total of all items, not items in specified date range.
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
Using a checkbox in formula
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
Abnormal Display of Hyperlink Content in Notification Emails
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…