Sign in to join the conversation:
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?
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...
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
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!
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:
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!
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
Hello Community, I need to create a report that shows capacity by month. My sheet tracks resource allocation on projects with resource start and end dates. (We can't afford the Resource Management module so we're doing it in Core SS). I've been asked to do a "heat map" of sorts where each column is a month. For each row…
