欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论，你想找到(或创建)一个更最新的版本，请访问当前论坛。

写以零“0”开头的邮政编码的问题

保罗
保罗 ✭
编辑12/09/19 在2016年发布的文章

你好,

我无法在文本/数字列中输入以“0”开头的邮政编码，它会自动删除零，只留下整数。是否有办法禁用此功能?

问候,

保罗

标签:
· 在Facebook上分享 在Twitter上分享

评论

这次讨论已经结束了。

类别

[Date of Site Survey (Product)]@row, \"yes\", \" \")) Intended logic\/result - If date cell is blank, then \"blank\" (this worked when I tried without the 2nd argument added) If date is in…","categoryID":322,"dateInserted":"2023-06-09T14:00:25+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:29:50+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:43:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162220,"lastUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:43:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3372641415,"url":"https:\/\/community.smartsheet.com\/discussion\/106265\/if-date-is-blank-past-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106265\/if-date-is-blank-past-formula","format":"Rich","lastPost":{"discussionID":106265,"commentID":379837,"name":"Re: If Date is blank + past formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379837#Comment_379837","dateInserted":"2023-06-09T14:29:50+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:43:14+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:28:35+00:00","dateAnswered":"2023-06-09T14:12:11+00:00","acceptedAnswers":[{"commentID":379830,"body":"

Try this:<\/p>

=IF([Date of Site Survey (Product)]@row <> \"//www.santa-greenland.com/community/discussion/5849/\", 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":106250,"type":"question","name":"Group & User Management - Sorting of Members","excerpt":"Hi I have 2 questions regarding Group Management... Does anyone know if it's possible to sort the Members alphabetically please? Even though they were imported in alphabetical order, when I open the group the list is randomly sorted. Not helpful when you're trying to search for a user within a list of 100 people. Is there…","categoryID":321,"dateInserted":"2023-06-09T05:36:26+00:00","dateUpdated":"2023-06-09T07:56:35+00:00","dateLastComment":"2023-06-09T12:50:31+00:00","insertUserID":162237,"insertUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162237,"lastUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3372605217,"url":"https:\/\/community.smartsheet.com\/discussion\/106250\/group-user-management-sorting-of-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106250\/group-user-management-sorting-of-members","format":"Rich","tagIDs":[442],"lastPost":{"discussionID":106250,"commentID":379805,"name":"Re: Group & User Management - Sorting of Members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379805#Comment_379805","dateInserted":"2023-06-09T12:50:31+00:00","insertUserID":162237,"insertUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T12:50:00+00:00","dateAnswered":"2023-06-09T11:29:41+00:00","acceptedAnswers":[{"commentID":379791,"body":"

HI @L Darvesh<\/a> <\/p>

  1. Currently there is no sorting inside of a group. Please vote for that functionality in this Enhancement Request:<\/li><\/ol>
    \n \n https:\/\/community.smartsheet.com\/discussion\/104139\/group-management-sorting-contact-list-alphabetically\n <\/a>\n<\/div>\n
    1. To my knowledge this is not available. As a System Admin on Enterprise Plan, I can export the User List and sort\/filter that way but it would be nice to be able to do this inside of Smartsheet. From Plan & Billing\/User Management I can filter but it does not count.<\/li><\/ol>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106239,"type":"question","name":"Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","excerpt":"I spent the last month building a solution for people to sign up for mentors by creating a sheet that has information about each mentor and lots of formulas color fields where someone has already signed up with only a max number of sign up fields (aka I can't do this in forms that I know of). I created a Dynamic View with…","categoryID":343,"dateInserted":"2023-06-08T20:54:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160816,"lastUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3372578665,"url":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","format":"Rich","tagIDs":[223,443],"lastPost":{"discussionID":106239,"commentID":379829,"name":"Re: Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379829#Comment_379829","dateInserted":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:07:07+00:00","dateAnswered":"2023-06-08T23:09:15+00:00","acceptedAnswers":[{"commentID":379755,"body":"
      \n \n https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login\n <\/a>\n<\/div>\n

      Hi Sara!<\/p>

      Dynamic View has its own settings for sharing that are separate from those on your underlying published sheet. If you haven't already shared the DV, itself (as well as the source sheet<\/em>), I think that may be the roadblock here. <\/p>

      When you open the settings for your DV, you'll see \"Sharing<\/strong>\" on the far right. I chose the Shared domains option at the bottom to ensure users enterprise-wide could access a particular DV I created, even if they didn't have a Smartsheet account. Adding the appropriate domain(s) (i.e., the part of your email address after the @<\/strong>; like CompanyXYZ<\/em>.com<\/em>) for your user audience should clear up the restrictions requiring sign-in.<\/p>

      If sharing at the domain level is too broad, I would suggest creating a named Group within the Smartsheet Admin Center (\"Group Management<\/em>\"). You can copy a list of email addresses and paste them into the \"Add Members\" field to \"bulk load\" a large group of users. Once your group is created, use the dropdown in the Shared groups option to select the appropriate group.<\/p>

      \n
      \n \n \"DV<\/img><\/a>\n <\/div>\n<\/div>\n

      I hope this helps resolve your problem! Please let me know how it goes!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":[{"tagID":223,"urlcode":"Publish","name":"Publish"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

      热门文章

      • 如果Date是空白+过去公式

        我不明白为什么这将返回一个“是”当日期单元格是空白。=IF([现场调查(产品)日期]@row = " "ob欧宝娱乐app手机下载， " "， IF(今天()>[现场调查(产品)日期]@row， "是"，" ")预期的逻辑/结果-如果日期单元格为空白，则"空白"(当我尝试不添加第二个参数时有效)如果日期在…

      • 组和用户管理-排序的成员

        嗨，我有两个关于集团管理的问题…有人知道能不能按字母顺序排序吗?尽管它们是按字母顺序导入的，但当我打开组时，列表是随机排序的。当您试图在100人的列表中搜索用户时，这是没有帮助的。有……

      • 的帮助!发布了任何人都可以编辑的工作表，但是动态视图需要登录

        上个月我花了一个月的时间为人们建立一个注册导师的解决方案，通过创建一个表格，其中包含每个导师的信息和许多公式颜色字段，其中有人已经注册，只有最大数量的注册字段(也就是说，我不能在我所知道的表格中这样做)。我创建了一个动态视图。