Filter tables based on dropdown menu selection

08/16/21
Accepted

Hi all. I've been tasked with mapping some data key connections between a large number of tables. I am looking for a way to display only the tables that match criteria from a single-select dropdown menu. Some pictures are below to illustrate what I'm looking for.

Here's what the raw tables look like. They are laid out like this, one after the other, for around 70 separate tables.

I have a dropdown list that lists all of the possible Column Names, and I'd like to be able to filter the tables above based on this dropdown.

My goal would be to select an option from this dropdown, then have ONLY the tables with that associated key filtered to be visible. So, if I want to know which tables use the ABSENT_DAYS key, I would select that from the dropdown, and every table without that key would be hidden, showing only the tables that use it.

I hope this makes sense. Please let me know how I can clarify further and thank you in advance for your time.

Best Answer

  • H.ColoH.Colo
    Accepted Answer

    Thanks Andrée, that will work!

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @H.Colo

    I hope you're well and safe!

    Have you explored using a report or filter instead? Is that an option?

    Would that work/help?

    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 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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • H.ColoH.Colo
    Accepted Answer

    Thanks Andrée, that will work!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @H.Colo

    Excellent!

    Happy to help!

    Remember! 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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.