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 formula running in a column to validate an action based on whether it was done prior to 01/01/2011 or not. =IF([Install Date]@row >= 1 / 1 / 11, "Yes", "No") The formula works as required on rows where there is a year only, but throws #INVALID OPERATION where a date has been entered through smartsheets…
Does anybody know what the "WBS Helper Columns->" column does in the Project with Work Breakdown Schedule (WBS) template? Is it just a helper column where a function could reside, or does it have an "Off the Shelf" purpose?
I need to build out a report that pulls the below information: Report needs to show the parent and child rows -Parent is not assigned but child is assigned -Parent is assigned and child is assigned I am open to helper columns but everything I have tired is not working. Formulas: -Parent Helper: =COUNT(ANCESTORS())…
