试图在ALL CAPS和Title CAPS中识别单元格
我有一个表，在那里我已经拉了一个列表的标题，存在于一系列的url在所有的大写或标题的情况下。我需要能够识别或排序所有大写的行，以便他们可以纠正-这是可能的吗?
最佳答案
-
詹姆斯•马 ✭✭✭✭✭把你的网址放在一个叫做in的字段里
创建一个名为OUT的字段，并输入以下公式:
=上((电子邮件保护)）然后创建两个字段，比如COUNT CAPS IN和COUNT CAPS OUT
计算大写字母:
=找到(“A”,(电子邮件保护)) + find (" b "，(电子邮件保护)) + find (" c "，(电子邮件保护)) + find (" d "，(电子邮件保护)) + find (" e "，(电子邮件保护)) + find (" f "，(电子邮件保护)) + find (" g "，(电子邮件保护)) + find (" h "，(电子邮件保护)) + find (" i "，(电子邮件保护)) + find (" j "，(电子邮件保护)) + find (" k "，(电子邮件保护)) + find (" l "，(电子邮件保护)) + find(“m”，(电子邮件保护)) + find(“n”，(电子邮件保护)) + find(“0”，(电子邮件保护)) + find (" p "，(电子邮件保护)) + find (" q "，(电子邮件保护)) + find(“r”，(电子邮件保护)) + find(“s”，(电子邮件保护)) + find(“t”，(电子邮件保护)) + find(“u”，(电子邮件保护)) + find (" v "，(电子邮件保护)) + find (" w "，(电子邮件保护)) + find (" x "，(电子邮件保护)) + find (" y "，(电子邮件保护)) + find (" z "，(电子邮件保护)）计数上限:
=找到(“A”,(电子邮件保护)) + find (" b "，(电子邮件保护)) + find (" c "，(电子邮件保护)) + find (" d "，(电子邮件保护)) + find (" e "，(电子邮件保护)) + find (" f "，(电子邮件保护)) + find (" g "，(电子邮件保护)) + find (" h "，(电子邮件保护)) + find (" i "，(电子邮件保护)) + find (" j "，(电子邮件保护)) + find (" k "，(电子邮件保护)) + find (" l "，(电子邮件保护)) + find(“m”，(电子邮件保护)) + find(“n”，(电子邮件保护)) + find(“0”，(电子邮件保护)) + find (" p "，(电子邮件保护)) + find (" q "，(电子邮件保护)) + find(“r”，(电子邮件保护)) + find(“s”，(电子邮件保护)) + find(“t”，(电子邮件保护)) + find(“u”，(电子邮件保护)) + find (" v "，(电子邮件保护)) + find (" w "，(电子邮件保护)) + find (" x "，(电子邮件保护)) + find (" y "，(电子邮件保护)) + find (" z "，(电子邮件保护)）如果这两个是相同的，那么就都是大写。
这只是将原始版本中所有的大写字母加起来，然后计算原始版本中所有大写字母的数量，并比较它们。
答案
-
marc4 ✭✭✭
一种真正懒惰的方法是将所有数据导出到google sheets，使用免费的ablebits功能工具将所有标题转换为小写字母，然后重新加载到smartsheet中。
/马克
-
詹姆斯•马 ✭✭✭✭✭
把你的网址放在一个叫做in的字段里
创建一个名为OUT的字段，并输入以下公式:
=上((电子邮件保护)）然后创建两个字段，比如COUNT CAPS IN和COUNT CAPS OUT
计算大写字母:
=找到(“A”,(电子邮件保护)) + find (" b "，(电子邮件保护)) + find (" c "，(电子邮件保护)) + find (" d "，(电子邮件保护)) + find (" e "，(电子邮件保护)) + find (" f "，(电子邮件保护)) + find (" g "，(电子邮件保护)) + find (" h "，(电子邮件保护)) + find (" i "，(电子邮件保护)) + find (" j "，(电子邮件保护)) + find (" k "，(电子邮件保护)) + find (" l "，(电子邮件保护)) + find(“m”，(电子邮件保护)) + find(“n”，(电子邮件保护)) + find(“0”，(电子邮件保护)) + find (" p "，(电子邮件保护)) + find (" q "，(电子邮件保护)) + find(“r”，(电子邮件保护)) + find(“s”，(电子邮件保护)) + find(“t”，(电子邮件保护)) + find(“u”，(电子邮件保护)) + find (" v "，(电子邮件保护)) + find (" w "，(电子邮件保护)) + find (" x "，(电子邮件保护)) + find (" y "，(电子邮件保护)) + find (" z "，(电子邮件保护)）计数上限:
=找到(“A”,(电子邮件保护)) + find (" b "，(电子邮件保护)) + find (" c "，(电子邮件保护)) + find (" d "，(电子邮件保护)) + find (" e "，(电子邮件保护)) + find (" f "，(电子邮件保护)) + find (" g "，(电子邮件保护)) + find (" h "，(电子邮件保护)) + find (" i "，(电子邮件保护)) + find (" j "，(电子邮件保护)) + find (" k "，(电子邮件保护)) + find (" l "，(电子邮件保护)row) + FIND("M"，(电子邮件保护)) + find(“n”，(电子邮件保护)) + find(“0”，(电子邮件保护)) + find (" p "，(电子邮件保护)) + find (" q "，(电子邮件保护)) + find(“r”，(电子邮件保护)) + find(“s”，(电子邮件保护)) + find(“t”，(电子邮件保护)) + find(“u”，(电子邮件保护)) + find (" v "，(电子邮件保护)) + find (" w "，(电子邮件保护)) + find (" x "，(电子邮件保护)) + find (" y "，(电子邮件保护)) + find (" z "，(电子邮件保护)）如果这两个是相同的，那么就都是大写。
这只是将原始版本中所有的大写字母加起来，然后计算原始版本中所有大写字母的数量，并比较它们。
帮助文章参考资料欧宝体育app官方888
类别
Try this:<\/p>
=IF([Date of Site Survey (Product)]@row <> \"//www.santa-greenland.com/community/discussion/comment/\", IF(TODAY() > [Date of Site Survey (Product)]@row, \"yes\", \"no\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":0}],"tags":[]},{"discussionID":106277,"type":"question","name":"Help creating formula to update inventory automatically","excerpt":"The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…","categoryID":322,"dateInserted":"2023-06-09T16:17:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T18:12:07+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161705,"lastUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3372664184,"url":"https:\/\/community.smartsheet.com\/discussion\/106277\/help-creating-formula-to-update-inventory-automatically","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106277\/help-creating-formula-to-update-inventory-automatically","format":"Rich","tagIDs":[204,219,254],"lastPost":{"discussionID":106277,"commentID":379911,"name":"Re: Help creating formula to update inventory automatically","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379911#Comment_379911","dateInserted":"2023-06-09T18:12:07+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FMANSEYA9OS3\/mm-brochures-request-sheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MM-Brochures-Request-Sheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T18:11:32+00:00","dateAnswered":"2023-06-09T17:51:51+00:00","acceptedAnswers":[{"commentID":379899,"body":"
