Sign in to join the conversation:
Expand / Collapse all is not an option on my primary nor any of my parent rows. Why?
This is probably because you moved the column. I would check each of your columns until you do see the options, and that column is considered your primary column.
I have renamed and moved that column many times in my history of Smartsheet. It's really easy to lose track of as your designing sheets. Our best practice is to make sure that the first column always stays the first column and you move the data as necessary to other columns if you change your design in the process.
Hi,
Expand / Collapse all is only available when you right-click (or click the menu in the column) on the Primary Column name.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Andree - you have just saved me constant hours of manually expanding and collapsing indented rows - I knew there must be a way 😁 Thanks
Hi @Garry Lofberg
I hope you're well and safe!
Glad to hear that it was helpful for you as well!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
If the option exists in the menu to collapse, this means that it should also be available in the functions list otherwise how can one do it programmable?
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
