公式和函数
讨论表
帮助文章参考资料欧宝体育app官方888
类别
受欢迎的标签
<\/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> Would any of those options 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"},"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":104891,"type":"question","name":"Sheet Summary fields not showing all data on Report","excerpt":"Please see the image. For some reason some sheet summary fields are not displaying on the report and others are. All are visible when I view the fields from the report. I've tried moving the sheet to a different workspace and folder, changed the values in the fields, etc., nothing works. Why are the green showing just fine…","categoryID":322,"dateInserted":"2023-05-05T15:15:46+00:00","dateUpdated":null,"dateLastComment":"2023-05-05T17:03:15+00:00","insertUserID":161194,"insertUser":{"userID":161194,"name":"jlee579","title":"Director of Customer Onboarding","url":"https:\/\/community.smartsheet.com\/profile\/jlee579","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T16:55:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145151,"lastUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2swDSBf8UVqLz0TNb7O4SvBO4L_SdaeBQp4xqD=s96-c","dateLastActive":"2023-05-05T23:03:26+00:00","banned":0,"punished":0,"private":true,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3366607741,"url":"https:\/\/community.smartsheet.com\/discussion\/104891\/sheet-summary-fields-not-showing-all-data-on-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104891\/sheet-summary-fields-not-showing-all-data-on-report","format":"Rich","tagIDs":[265,335],"lastPost":{"discussionID":104891,"commentID":374628,"name":"Re: Sheet Summary fields not showing all data on Report","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/374628#Comment_374628","dateInserted":"2023-05-05T17:03:15+00:00","insertUserID":145151,"insertUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2swDSBf8UVqLz0TNb7O4SvBO4L_SdaeBQp4xqD=s96-c","dateLastActive":"2023-05-05T23:03:26+00:00","banned":0,"punished":0,"private":true,"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\/EKNS5NMROOE6\/summary-field-to-report-issue.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Summary Field to Report Issue.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-05T16:55:15+00:00","dateAnswered":"2023-05-05T16:40:15+00:00","acceptedAnswers":[{"commentID":374626,"body":"