PROPER将“ALL CAPS”设置为“ALL CAPS”
我有一张很长的纸，上面所有的文字都是大写的。我知道UPPER和LOWER函数会将整个句子改为小写，但是是否有一个适当的函数(如excel)将句子的第一个字母大写，随后的字母小写?
评论
-
Shaine格林伍德 员工你好sojourner16,
目前还没有一个PROPER函数或等效函数可以将文本字符串转换为句子大小写。此时，您需要手动更改文本以反映您想要的句子大小写。
当您有时间时，请使用社区网站右侧快速链接下的产品增强请求表单提交您对适当功能的增强请求。ob欧宝娱乐app手机下载
-
迈克尔。贝克 ✭
我开始觉得这是某种糟糕的笑话……出于很多原因，我真的很喜欢SmartSheet，但我对它的Function引擎的弱支持和有时奇怪的任意支持感到沮丧。你有and UPPER()和LOWER()，为什么没有PROPER()?我可以理解有一些特殊的考虑使得支持某些功能变得困难或不切实际，但这似乎是一种疏忽。
-
mdFleet ✭
我对Smartsheet很陌生，这让我措手不及。手动调整数百个条目是非常耗时的，而这本来可以在一瞬间完成。
类别
We thank you for your patience while we iron out some of the kinks with the new Search UI. We've released two updates today that resolve some of the concerns raised here.<\/p>
- If you are searching for a numeric or alphanumeric term, you will get an exact match of the search term you entered, thereby resolving some of the previous search relevance concerns.<\/li>
- When clicking on a search result, you will go directly to that result instead of the top of the sheet containing that result. However, if you only want to go to the sheet containing the search result, click the icon to the right of the sheet name. <\/li><\/ol>
We'll keep you updated with any new improvements to the Search experience.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 12:13:12","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-16T09:10:31+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[]},{"discussionID":98881,"type":"question","name":"Add image to the Smartsheet Form (Questionnaire)","excerpt":"Hi Smartsheet Form Expert, I have created a Form (Questionnaire). One of the questions in the Questionnaire is as follows: \"Is there any other information you would like to share regarding your suggestion?\" In Smartssheet Form, would it be possible for the respondents to insert\/attach an image to support their response?…","categoryID":321,"dateInserted":"2022-12-16T22:32:35+00:00","dateUpdated":null,"dateLastComment":"2022-12-16T23:08:07+00:00","insertUserID":129126,"insertUser":{"userID":129126,"name":"Marie_T","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Marie_T","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4QwOlNaaGK3XDjKxWN7oB8bExoh_uHbwIt5OGs=s96-c","dateLastActive":"2022-12-16T23:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":129126,"lastUser":{"userID":129126,"name":"Marie_T","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Marie_T","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4QwOlNaaGK3XDjKxWN7oB8bExoh_uHbwIt5OGs=s96-c","dateLastActive":"2022-12-16T23:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":16,"score":null,"hot":3342463242,"url":"https:\/\/community.smartsheet.com\/discussion\/98881\/add-image-to-the-smartsheet-form-questionnaire","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98881\/add-image-to-the-smartsheet-form-questionnaire","format":"Rich","lastPost":{"discussionID":98881,"commentID":354747,"name":"Re: Add image to the Smartsheet Form (Questionnaire)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354747#Comment_354747","dateInserted":"2022-12-16T23:08:07+00:00","insertUserID":129126,"insertUser":{"userID":129126,"name":"Marie_T","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Marie_T","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp4QwOlNaaGK3XDjKxWN7oB8bExoh_uHbwIt5OGs=s96-c","dateLastActive":"2022-12-16T23:06:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O7QLMINQ41YZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-16T23:06:45+00:00","dateAnswered":"2022-12-16T22:45:02+00:00","acceptedAnswers":[{"commentID":354741,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/59849J53RZ7L\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
