限制文本/数字列的格式
你好所有的,
我已经挖了足够的地方，以确定没有功能来限制列的特定数据类型(即限制文本/数字列只有6个数字)。这是一个非常有用的东西，尤其是我和我的智能表格同事们经常使用的表格。
如果Smartsheet添加了这个功能，它将使表单的使用更加强大。
谢谢你！
评论
-
Shaine格林伍德 员工你好,
在一定程度上，可以限制列只允许某些数据类型。(更多信息见列类型帮助文章.）
您是正确的，Smartsheet目前没有这种级别的数据验证，因此列仅限于某些字符和字符限制。
当您有时间时，请使用社区网站右侧快速链接下的表单提交产品增强请求，以让我们的产品ob欧宝娱乐app手机下载团队知道您希望在Smartsheet的未来版本中添加此功能。
-
卡罗琳·谢尔登 员工
类别
Hi @Andrew Foster<\/a> <\/p> I hope you're well and safe!<\/p> Unfortunately, it's not possible now, but it's an excellent idea!<\/p> Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic weekend!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 11:26:04","updateUser":{"userID":137901,"name":"Andrew Foster","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Foster","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T13:46:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":97633,"type":"question","name":"How to change status for one product type when a new item is added with the new status.","excerpt":"Hello, I am tracking project submissions in a smartsheet list. Each project may has more than one phase, so the project steps appear in separate lines. When someone submits the final step, I would like the status column next to each step of the project to show \"complete\" (or checked). I think this would be a workflow…","categoryID":343,"dateInserted":"2022-11-10T21:31:55+00:00","dateUpdated":"2022-11-11T08:04:39+00:00","dateLastComment":"2022-11-11T19:59:41+00:00","insertUserID":153468,"insertUser":{"userID":153468,"name":"BWheel","url":"https:\/\/community.smartsheet.com\/profile\/BWheel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T18:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-11-11T20:04:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":35,"score":null,"hot":3336316296,"url":"https:\/\/community.smartsheet.com\/discussion\/97633\/how-to-change-status-for-one-product-type-when-a-new-item-is-added-with-the-new-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97633\/how-to-change-status-for-one-product-type-when-a-new-item-is-added-with-the-new-status","format":"Rich","lastPost":{"discussionID":97633,"commentID":350902,"name":"Re: How to change status for one product type when a new item is added with the new status.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350902#Comment_350902","dateInserted":"2022-11-11T19:59:41+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-11-11T20:04: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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NLKRL7GUO1C5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-11T17:35:28+00:00","dateAnswered":"2022-11-11T17:21:17+00:00","acceptedAnswers":[{"commentID":350882,"body":" You would use a column formula such as this (in the checkbox column):<\/p> =IF(COUNTIFS([Project ID]:[Project ID], @cell = [Project ID]@row, [Is this completed?]:[Is this completed?], @cell = \"Yes\") > 0, 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-11 17:35:28","updateUser":{"userID":153468,"name":"BWheel","url":"https:\/\/community.smartsheet.com\/profile\/BWheel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-11T18:07:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
