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.
Card View - How does sorting and card position work?
Hello,
Card View is great. I wanted to start a separate thread specfic to card sorting and card column positions in Card View. Here are my initial questions.
1) What is the default sort/order within each column for cards in Card View?
2) What happens when a card is re-ordered, in the same column?
3) Is there a value that changes for the position of the card when the card is moved? If so, can end users see that value? Can end users change that value directly?
4) Will the changed position be remembered when coming back to the sheet or going between other views and back to Card View?
Thanks!
-Stan
Comments
-
Heidi Decker ✭✭✭✭✭✭
Hi Stan,
I asked all the same questions a little earlier except #4.
I have the answer to #4. YES it stays in the same position in card view when you go back and forth and it DOES NOT change where it is in the grid view. It only changes how you see it in the Card View.
I guess the answer to # 2 would be, "nothing except where you see it in the view"
-
Jason Employee
Default sort order is row order in grid view. New rows added in grid view are added to the bottom of whatever lane it belongs in in card view.
When a card is moved its position is saved. Sheet collaborators all see the same card order/rank. Card rank is different and saved separately for each viewBy column (the column selected in the viewBy drop down menu.) Changes to card order/rank do not affect row order in grid view.
As we store card rank, there is value that changes when a card is moved, but end users can't see that value. Moving a card via drag/drop is currently the only way for a user to directly change a card's rank. There are actions that effect ranks however, deleting cards, insert cards above/below via the card menu, to name a few.
跳e this helps!
-
Thanks Heidi and Jason. Good info. Sorry I mised Heidi's earlier Q&A on this. I use a lot of reports for my viewing of tasks and often use a "forced rank" column for sorting. I can imagine using the card position value somehow instead of the forced rank that I use, so it might be helpful to someday expsose the card positon value.
Thanks again,
Stan
-
Mashcan ✭
Row order is sort of ok, I'd rather be able to choose the parameter (such as start or finish date) but is there a way to reset the values? So like if I add a bunch of lines and it puts them all at the bottom, can I say, start over and order them according to the rows they're in? Also assuming this will forget any instances of rows that were manually shifted.
-
Kennedy Stomps Employee
Hi Mashcan-- There isn't currently a way to "reset" the cards in the Card View, but I've added your vote for this to our enhancement request list. Great suggestion!
-
Is there a way to manipulate this through the API?
-
Jason Employee
Hi Dennis-- There isn't a way to directly manipulate card ranks directly via tha API at present.
-
Any progress on this? I'm migrating some stuff from Trello and would REALLY like to be able to sort in Card view as we do in Grid view.
Thanks!
Jon
-
Brad Jones ✭✭✭✭✭✭
Where are we at on this one?
I really think that it would be VERY useful to be able to sort your swimlanes by criteria that you choose. Especially things like date, priority, % Complete, Harvey Ball... anything.
And, if you fear messing up the order of other things, this could be managed easily enough. Already in the SS system you allow each card to have a 'rank' identifier. Tie this into the requested sort parameter and then re-assign the card ranks based upon this 'rank' parameter.
-
Hello Smartsheet team, I see this idea was proposed 2 years ago. Do you know if it has been released/approved? I have tried to sort by date in the card view. Your help is appreciated.
-
yeah come on guys - can't be that difficult - you can't claim to Agile when you fail at this simple feature - sorry to be straight but how many years to upgrade this to the be congruent with your marketing materials?
-
Zachw ✭✭✭
Related question: When you drag card from one lane to another lane. It drops to bottom of that lane.
I want to switch that (so dragging to a lane moves card to top of lane) - is that possible to do right now?
Also adding my support to more advanced automated card sorting that others have requested in this thread
-
埃里克·詹森 ✭✭✭
Please get this done. +1 from me.
-
Coming from TeamWork Projects that has it and made me believe that sorting in the card view by date or other criteria is a given. Turns out, not with SmartSheet. Quite surprised and hoping for resolution.
Categories
Try IF([payment voucher]@row=0,Sum([Parking Revenue Regular]@row:[Private boat parking revenue]@row),\"//www.santa-greenland.com/community/discussion/comment/\")<\/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":106894,"type":"question","name":"How to Count a value in a drop down \/ multi-selection list?","excerpt":"Hi, I'm wanting to count the total amount time this value \"VAVE\" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…","categoryID":321,"dateInserted":"2023-06-26T15:09:07+00:00","dateUpdated":"2023-06-26T15:09:27+00:00","dateLastComment":"2023-06-26T20:54:24+00:00","insertUserID":162246,"insertUser":{"userID":162246,"name":"Shawn_K2","url":"https:\/\/community.smartsheet.com\/profile\/Shawn_K2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nPFlXyflhuI!uj8vZ9JIm_o!1axowkoO9t8","dateLastActive":"2023-06-26T20:56:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162246,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-27T04:13:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":58,"score":null,"hot":3375609211,"url":"https:\/\/community.smartsheet.com\/discussion\/106894\/how-to-count-a-value-in-a-drop-down-multi-selection-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106894\/how-to-count-a-value-in-a-drop-down-multi-selection-list","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106894,"commentID":382446,"name":"Re: How to Count a value in a drop down \/ multi-selection list?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382446#Comment_382446","dateInserted":"2023-06-26T20:54:24+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-27T04:13:24+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\/LKT88AUTSMAT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-26T16:54:33+00:00","dateAnswered":"2023-06-26T16:44:18+00:00","acceptedAnswers":[{"commentID":382355,"body":"