Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Multiple Filters in a Column

    ✭✭
    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.

    · Share on FacebookShare on Twitter

    Answers

    • Community Champion

      @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.

      Always happy to work through questions or concerns!

      · Share on FacebookShare on Twitter
    • ✭✭

      Yep, didn't think of that. thanks

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions