Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Hiding rows
I would like to be able to hide rows can only find option of hiding columns. It would be especially helpful if hiding rows option could be added to conditional formatting.
Comments
-
J. Craig Williams ✭✭✭✭✭✭你唯一的选择卡伦牌tly are Filters and Reports.
Craig
-
What I do in this senario is add an "Admin" row at the bottom of my sheet and then collapse rows beneath it into child rows. Most folks, in my experience, typically don't look at those last few rows especially if they're collapsed.
-
J. Craig Williams ✭✭✭✭✭✭
Good tip Claire.
-
Claire, AWESOME TIP! Thank you!
-
I would love having conditional formatting to hide a row. That would make the sheet so neat looking.
So based on the data in a previous row in a parciular column another row could be hidden untill the right data is set.
Also having different drop down menus in in the same column would be very useful.
-
carriej2 ✭✭
I would love to have a "hide row" feature like Excel. I don't understand why you'd only have a hide column feature without a hide row feature as well. It's just as important to be able to do both. I use it in Excel all the time. I also don't want to have to do conditional formatting or formulas for a simple task like this. Smartsheet is being promoted as being better than Excel, but there are a lot of extremely useful features that it doesn't have compared to Excel. I find that I often have to export my Smartsheet to Excel in order to manipulate my data in the way that I need it.
Smartsheet - Please listen to your users and build in this hide rows feature.
Categories
You can do this using a cross sheet reference.<\/p>
=JOIN(COLLECT({TeamTeam}, {TeamDepartment}, Department@row), \", \")<\/p>
TeamTeam references the Team column on the Team sheet, and TeamDepartment references the Department column on the Team sheet.<\/p>
Hope this helps.<\/p>
Matthew<\/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":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":112256,"type":"question","name":"Dashboard Views","excerpt":"It would be helpful to know how many views a dashboard is getting to see if it's effective","snippet":"It would be helpful to know how many views a dashboard is getting to see if it's effective","categoryID":321,"dateInserted":"2023-10-27T13:16:00+00:00","dateUpdated":"2023-10-27T14:23:56+00:00","dateLastComment":"2023-10-27T14:24:23+00:00","insertUserID":153592,"insertUser":{"userID":153592,"name":"nancy.mina","url":"https:\/\/community.smartsheet.com\/profile\/nancy.mina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WTjeHghqMDQ!hHtd4ZRALXo!6Fyi9bnhkuz","dateLastActive":"2023-10-27T14:07:03+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-10-27T15:53:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":16,"score":1,"hot":3396831323,"url":"https:\/\/community.smartsheet.com\/discussion\/112256\/dashboard-views","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112256\/dashboard-views","format":"Rich","lastPost":{"discussionID":112256,"commentID":402018,"name":"Re: Dashboard Views","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402018#Comment_402018","dateInserted":"2023-10-27T14:24:23+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-10-27T15:53:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-27T14:24:11+00:00","dateAnswered":"2023-10-27T13:38:24+00:00","acceptedAnswers":[{"commentID":402006,"body":"
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/083246FKS6MW\/screenshot-2023-10-27-at-14-37-14.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
