想要直接在智能表中练习使用公式吗?

请查看公式手册模板查看100多个公式,包括每个函数的术语表以及常用和高级公式的示例。

公式和函数

被公式难住了?寻求帮助或找一些例子,看看别人是如何使用公式来解决类似的问题的。

讨论表

帮助文章参考资料欧宝体育app官方888

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
\n \n https:\/\/help.smartsheet.com\/learning-track\/smartsheet-intermediate\/reports\n <\/a>\n<\/div>


<\/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":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]},{"discussionID":104914,"type":"question","name":"Restricting populating only one cell in a row","excerpt":"Hello, I have a grid (spreadsheet) with five rows. Is there a way to restrict the selection to one cell? In other words, if one cell is populated, the other four should automatically be restricted. I do not want the participants to be able to populate more than one cell in the row..","categoryID":322,"dateInserted":"2023-05-06T12:10:02+00:00","dateUpdated":null,"dateLastComment":"2023-05-06T12:31:12+00:00","insertUserID":137906,"insertUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-06T20:50:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-08T11:29:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":47,"score":null,"hot":3366751874,"url":"https:\/\/community.smartsheet.com\/discussion\/104914\/restricting-populating-only-one-cell-in-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104914\/restricting-populating-only-one-cell-in-a-row","format":"Rich","lastPost":{"discussionID":104914,"commentID":374712,"name":"Re: Restricting populating only one cell in a row","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/374712#Comment_374712","dateInserted":"2023-05-06T12:31:12+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-08T11:29:44+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-05-06T14:24:01+00:00","dateAnswered":"2023-05-06T12:31:12+00:00","acceptedAnswers":[{"commentID":374712,"body":"

Hi @Vinton Douglas<\/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>