PROPER Function to change ALL CAPS to All Caps

sojourner16

I have a very long sheet where all text was written in upper case.  I know the UPPER and LOWER functions will change the entire sentence to lower case, but is there a PROPER function (like in excel) to capitalize the first letter of the sentence with the subsequent letters in lower case?

Shaine Greenwood

Hello sojourner16,

There currently isn't a PROPER function or equivalent function that will convert text strings to sentence casing. At this time, you'll need to manually change the text to reflect the sentence casing you want.

When you have a moment, please submit your enhancement request for a PROPER function using the Product Enhancement Request form under Quick links on the right of the community site.

 

Michael.Baker

I'm starting to feel like this is some kind of bad joke... I really like SmartSheet for a lot of reasons but I grow ever frustrated with the weak and at times strangely arbitrary support of it's Function engine.  You have and UPPER() and LOWER() why leave out PROPER()?  I can appreciate that there are special considerations that make supporting certain functions difficult or impractical but this just seems like an oversight. 

mdFleet

I'm very new to Smartsheet and this took me off guard. It's very time consuming to manually adjust hundreds of entries when it could be done in a snap.