Collapse/expand rows
Hi Community!
Silly question... sorry for that 😊
My boss and I are sharing a list of tasks, some of which are parents of sub-tasks...
When I use the sheet and collapse/expand rows and save, smartsheet will save my action and next time my boss or I open it, it will show the rows as I left them. This is not the case for my boss...
Any idea of a settting that could impact this? We have read all basic articles about hierarchy, checked all settings... this is driving us mad!
Thank you in advance!
Best Answer
-
The problem comes from the filter. if you have a filter, then smartsheet automatically expand rows that are not included in your filter.
There is another threat dating 2016 that has been closed. but apparently the problem has not been resolved.
Answers
-
Hi @Aline
Hope you are fine, Unfortunately, this feature is not currently available. but you can play around by using the report for you to update and keep the original sheet for your boss 😉.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Aline
What permissions does your boss have to the sheet?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks very much for taking the time to answer.
He's the owner and I am an admin...
Have a great week too!
-
Thanks very much for taking the time to answer.
In fact, we would like that when a row is collapsed (i.e. tasks and sub-tasks all completed) it remains collapsed the next time the sheet is opened. This actually works for me but not for my boss, regardless of who did collapse and save the file.
I think the only setting difference might be that I have the autosave function upon closing the sheet turned on and my boss not...
Have a great week.
-
Happy to help!
How does your Boss access the sheet? Saved a link in the browser? If that is the case, the link might be saved with a specific view.
Did that help?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I'll have a look at that! Thanks for the hint... will let you know
-
You're more than welcome!
If that doesn't solve it, I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
The problem comes from the filter. if you have a filter, then smartsheet automatically expand rows that are not included in your filter.
There is another threat dating 2016 that has been closed. but apparently the problem has not been resolved.
-
Hello Community
We finally found out why the collapsed row would always expand when re-opening the file: if a filter is on then it will show the related value regardless the collapsed row... so it expands the collapsed row ;)
Happy weekend to all!
-
Is there a fix yet for why collapsed rows don't stay collapsed with a filter on for something else?
This is very frustrating.
-
This is a daily issue for us as well. Commenting to be alerted when a solution is available.
-
Commenting to be alerted when a solution is available. This is a daily struggle for our team and frustrating during meetings when sheets auto save and then re-expand all rows. Typically this occurs in the middle of a discussion about a specific parent row. This results in a pause of the meeting so the presenter can again collapse all rows and regain their focus on the topic at hand.
Any possible fixes or solutions for this yet? A keyboard shortcut for the desktop app for both expand and collapse would be wildly helpful.
-
+1 This is really frustrating.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives