If i push a date out on one of my line items and sort by date; the changed line item will only drop to the bottom of the month that it currently exists in. How do i get the line item to sort to it's proper "new" date?
Not sure I follow!
Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
I hope that helps!
Have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
here are screen shots of my actions. Notice line item TEST highlighted red. I change the date from March 5th to May 5th, then sort by date in the date column. The TEST line item only drops to the end of March, it does not move to May 5th.
Now I see. It's because you have parents/children. It will sort by the parents first.
hmm no, haha. so is it the way i am selecting the values when sorting? if so, what SHOULD i be doing?
I believe Andree is correct. You see this thing in the circle? That's a parent row. If you didn't mean to have parent/child rows, then select all the rows underneath the row with the dash, and click the "Outdent" button. That will remove the parent/child relationship and let you sort properly.
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
See my example:
When I sort ascending by Submission date, it sorts the parent rows first, then it sorts the child rows but only within the group of child rows:
this worked! thank you so much
You're welcome! If you could mark our answers as accepted, that will help others find them when they encounter the same issue.
Happy to help!
✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.