在网格中将列分组
劳拉·佩恩
✭✭
嗨！我使用一个非常大的网格式智能表来跟踪项目开发和健康的各个方面。拥有一种对列进行分组的方法将非常有帮助。行的层次结构工作得很好，但我认为我只是在寻找一种方法来清理我的视图。
我觉得现在最好的(也是唯一的)解决方案是使用报表。但是现在我有这么多的报告，很难追踪所有这些。
评论
-
Sameer Karkhanis ✭✭✭✭✭✭
添加分组列的功能(像MS Excel一样)-可以节省一些水平滚动，并有助于在需要的基础上显示列。
-
尼克富恩特斯 ✭✭✭✭✭我也有大量的总结表，里面有大块的相关栏目。除了给它们上色之外，对它们进行明显分组的能力将是巨大的。即使只是在整个群体周围涂上颜色也能创造奇迹。
如果你可以隐藏/取消隐藏作为一个组。
-
wfowler ✭
你好,
如果可以通过创建层次系统对列进行分组，就像对行进行分组一样，这将是一个很棒的功能。谢谢你！
-
fmoser ✭
足够地说。如果能够按功能或类别分组列就太好了。
-
wfowler ✭
如果您可以将列与行具有完全相同的层次结构系统进行分组，这将非常有帮助。对于伯克利音乐学院来说，这是一个成败攸关的特点，因为我们正在考虑在整个学院内更大规模地采用Smartsheet。谢谢你！
-
内特 ✭
嘿,
我想对列进行分组
-
劳拉·佩恩 ✭✭
你好!我知道我和其他队友都遇到过这个问题。我也在问答中看到过。请，请，请创建分组列的方法。这快把我逼疯了。Smartsheet有很多出色的功能。我们能加上这个吗?
-
MattS345 ✭我们的组织使用一个中央表格，它容纳了大约350列，很难导航。工作表可以具有的一个很好的功能是将列分组并对其进行标记，然后还可以创建一个链接到工作表内这些组的目录。
-
菲尔·怀特曼 ✭✭✭✭✭听起来你在谈论“父母”专栏?例如，从组织结构的角度来看，你可能有一列是部门，然后是分支，然后是单位，你想要“卷起/折叠”它们。
它可能是一个简单的隐藏列在上面的例子。如果它的数值会用公式来求解。例如，FY求和月，月求和周，周求和日?
最后是你提到的报道。
希望这对你有帮助。
该公司
菲尔。
类别
2023-05-07T14:03:10.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106001,"type":"idea","name":"automation workflow approval - Use form to request additional information prior to Approve\/Deny","excerpt":"I am looking for the ability for the approver to ask a questions (normally from the requester) prior to making a final selection of Approve\/Deny. Currently the approval form has access to the comment field but the only way for the form to process something added to the comment field is if you select Approve or Deny (Which…","categoryID":349,"dateInserted":"2023-06-05T12:22:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T20:29:41+00:00","insertUserID":156479,"insertUser":{"userID":156479,"name":"Joe Luc","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Luc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T21:11:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":156479,"lastUser":{"userID":156479,"name":"Joe Luc","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Luc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T21:11:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":47,"score":3,"hot":3372054423,"url":"https:\/\/community.smartsheet.com\/discussion\/106001\/automation-workflow-approval-use-form-to-request-additional-information-prior-to-approve-deny","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106001\/automation-workflow-approval-use-form-to-request-additional-information-prior-to-approve-deny","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106001,"commentID":379156,"name":"Re: automation workflow approval - Use form to request additional information prior to Approve\/Deny","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379156#Comment_379156","dateInserted":"2023-06-06T20:29:41+00:00","insertUserID":156479,"insertUser":{"userID":156479,"name":"Joe Luc","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Luc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T21:11:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106043,"type":"idea","name":"Forms: Contact List Default Setting Current User","excerpt":"When adding a contact list field to a form. I have noticed the need for an option of current user as a default setting. Some forms are repetitive and require an email often times that of the user filling out the form. This would greatly enhance the form experience and optimize user time.","categoryID":349,"dateInserted":"2023-06-05T22:51:39+00:00","dateUpdated":"2023-06-06T09:33:49+00:00","dateLastComment":"2023-06-06T09:37:16+00:00","insertUserID":159222,"insertUser":{"userID":159222,"name":"Lou Cav","url":"https:\/\/community.smartsheet.com\/profile\/Lou%20Cav","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p89Z6cXL3Ho!k8FafyWeRXo!b9B-ai4Twfw","dateLastActive":"2023-06-05T22:47:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T14:01:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":1,"hot":3372050635,"url":"https:\/\/community.smartsheet.com\/discussion\/106043\/forms-contact-list-default-setting-current-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106043\/forms-contact-list-default-setting-current-user","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106043,"commentID":378946,"name":"Re: Forms: Contact List Default Setting Current User","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378946#Comment_378946","dateInserted":"2023-06-06T09:37:16+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T14:01:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":105956,"type":"idea","name":"Feature Request - Dashboard Line Chart Colour Change","excerpt":"Good Morning, Firstly, the rebrand of the dashboards is fantastic - I had raised this as a feature request late last year and am so excited to use the new background colours and widget colours. Really good - thank you and thank you for listening to user requests :) I do have a further request if I may? On a line chart, the…","categoryID":349,"dateInserted":"2023-06-02T15:04:42+00:00","dateUpdated":"2023-06-05T09:20:49+00:00","dateLastComment":"2023-06-02T16:25:28+00:00","insertUserID":155892,"insertUser":{"userID":155892,"name":"bhiggins","url":"https:\/\/community.smartsheet.com\/profile\/bhiggins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T15:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":150051,"lastUser":{"userID":150051,"name":"DebRichardson","title":"Senior Administrative Assistant for the Office of Research Operations","url":"https:\/\/community.smartsheet.com\/profile\/DebRichardson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2023-06-02T16:26:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":2,"hot":3371442610,"url":"https:\/\/community.smartsheet.com\/discussion\/105956\/feature-request-dashboard-line-chart-colour-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105956\/feature-request-dashboard-line-chart-colour-change","format":"Rich","tagIDs":[292,363],"lastPost":{"discussionID":105956,"commentID":378599,"name":"Re: Feature Request - Dashboard Line Chart Colour Change","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378599#Comment_378599","dateInserted":"2023-06-02T16:25:28+00:00","insertUserID":150051,"insertUser":{"userID":150051,"name":"DebRichardson","title":"Senior Administrative Assistant for the Office of Research Operations","url":"https:\/\/community.smartsheet.com\/profile\/DebRichardson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2023-06-02T16:26:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
