可扩展/可折叠列与按钮(不隐藏)?

是否有任何功能在智能表类似于这个excel屏幕截图列能够在一个分组中展开和折叠使用一个按钮?

当前的场景是供应商联系信息被附加在工作表末尾的几个列中,它不是常规使用的信息,但需要附加到每一行,因此将其折叠在分组中将有助于清理工作表。

为了进一步简化请求,在这种情况下,简单地隐藏列对我们来说是无效的,而且我还没有成功地将工作表转换为报告,除此之外,如果可能的话,我希望使用工作表而不是报告。


谢谢!

答案

@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/p>"}]}},"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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106272,"type":"question","name":"Automation to send past due notifications to members","excerpt":"Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…","categoryID":321,"dateInserted":"2023-06-09T14:40:21+00:00","dateUpdated":"2023-06-09T14:48:10+00:00","dateLastComment":"2023-06-09T15:01:14+00:00","insertUserID":162249,"insertUser":{"userID":162249,"name":"blake_smith_b","title":"Accountant - Financial Reporting","url":"https:\/\/community.smartsheet.com\/profile\/blake_smith_b","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3372645095,"url":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106272,"commentID":379850,"name":"Re: Automation to send past due notifications to members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379850#Comment_379850","dateInserted":"2023-06-09T15:01:14+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XJX8FMEG7M9C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:12:48+00:00","dateAnswered":"2023-06-09T15:01:14+00:00","acceptedAnswers":[{"commentID":379850,"body":"

In the Trigger section, select \"When a date is reached\",<\/p>

Then select \"Custom\" for when to run the automation, and select \"Repeat Every\" and choose 1 Day.<\/p>

Then select your Conditions. For yours, you can say \"Where Past Due?\", and select \"is one of\", then choose \"Past Due\"<\/p>

Example below.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"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":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"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":23,"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"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">