Multiple Filters in a Column

Options
drichart
drichart ✭✭
edited 03/26/24 in Formulas and Functions

I have a column for State where work is being done in. I need to set up a separate filter for West, Central, and East Regions with their perspective states. Does anyone have an idea on how to achieve this? I'm not seeing anything for any comma separators anywhere.

Answers

  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭
    Options

    @drichart

    If you are wanting to capture West / Central / East regions, are you capturing that information anywhere? Is that field a drop down? If you you would be able to create a filter where that field is one of, and then list the applicable states that should be contained.

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

  • drichart
    Options

    Yep, didn't think of that. thanks

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!