Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
What would be nice is if there was a way to expand/collapse rows by level of hierarchy. This would be very helpful as errors in formulas are discovered and need to be corrected. Currently, you have to expand each hierarchy level to make mass corrections.
You can right click on the Primary Column header and choose the option to "Expand all" -- which will expand the entire sheet!
Yeah, but many times you do not want to expand them all - you just want to expand one level at the time (or one branch).
Hi Chris, Mike & Tomas,
A possible workaround but it depends on your specific sheet.
If you can search for something unique, that is on all of the branches or column indicating what level it belongs to. I use this method all the time.
E.g., I have a construction diary that I built for a client, and it looks the same for every day. If i just want to see a specific level of information, I search for it, and that expands the particular sections.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
1. Right click on the column header
2. Filter
3. "name of column" - contains - #
as "#" appear in all error messages. You can be more precise in the request to select more specific error messages
And you may tick the box "❏ Include parent row" for a better understanding of the rows that will appear of course.
What I have is contracts. Each contract has revenue and cost assigned by a month. Each month may have 1 or more items, those items may have 1 or more subitems. When you're running calculations that eventually SUM(CHILDREN) to parent rows and you have logic calculations to evaluate the status of a contract or child row of that contract, the ability to open all 1st or 3rd level hierarchy takes forever without this function. Excel accomplishes this with the Grouping function. All I am saying is that it would be efficient if the primary column had a tool that would expand all rows by 2nd, 3rd, etc hierarchy level. I have several clients and the largest client has 78 different contracts with a total over 1000 rows of sub-level rows.
As you're building a solution, the ability to edit "errors" or add new calculations takes extra time with the hierarchy functionality. We're using Smartsheet because we don't have software that does this all for us, and we're having to build the solution as we go. If Smartsheet is going to base their entire product on hierarchy, it only makes sense to be able to drill quickly to any level of hierarchy on that sheet.
Chris,
Here is another possible solution that may work for you. By using this formula (=IF(Column1 = "", "", COUNT(ANCESTORS(Column1))) in a 'Level' column, you will get a number for each row that is at the same level in the hierarchy. You can then set up filters--either inclusive (levels 0-2) or exclusive (just level 2, for example). So I think it would achieve what you are trying to do.
Steve
=COUNT(ANCESTORS([Column Name]@row))
Does the same thing, but cuts out the IF. I've found that the more parts you have, the easier it is to break.
Yes. That would work. But wouldn't it be sweet if you didn't have to use a formula for functionality. My point was more of a suggestion for Smartsheet. I leave my job for another that I don't believe uses SS, so this will be the end of my part of the thread.
All in all. SS is a good tool.
Peace!
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
