When a filter is applied I can only see the parent rows and would like to expand the sections below. Can anyone suggest how I can do this please?
You'd probably need to filter differently.
Can you describe your process in more detail and maybe share the sheet(s) or 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 day!
Workflow Consultant / CEO @ WORK BOLD
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.
HI. Thanks for responding. Attached is a screenshot of the sheet after filtering and a shot of the filter itself. Thanks
Happy to help!
Can you also share a screenshot of at least one parent expanded?
Sure. Please see attached. Thanks
What are the four values you have for the Award Status?
Do you always want to show the parents if one of the children match the filter?
For clarity, It's not possible to expand the filtered view, so we will need to create a filter that shows parents and children in the way that you need to.
Ah OK, yes makes sense.
The values under award status are:
Approved with Queries
We give grants to various organisations, so Id like to be able to filter successful grants from a particular organisation and then be able to expand from there. But if I cant, then yes, creating a better filter sounds like a good plan!
For this I generally will add in a hidden checkbox column then write out two IF statements. One for the children rows that says if it meets "x criteria" (whatever you are trying to filter on), then check the box, then another for the parent rows that says if there are any children checked then check the parent box. I then build my filter off of the new checkbox column.
@Maricia Klincke Do you need any help setting it up?
Sounds complicated! I'll have a look and shout if I need some help. Thank you so much for taking the time to help me.
I'm always happy to help!
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
Hello, I have this formula to return the number of items that have not been ordered. The formula works perfectly so I want to make it a column formula but get the below error. =COUNTM(PPE10) + COUNTM(Tooling@row) + COUNTM(Consumables@row) + COUNTM([QEW LOTO]@row) + COUNTM([Rigging/Basket Access]@row) + COUNTM(Fillers@row)…
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.