How would I set up filters or a formula to pull in data from two columns and numbers in between?

Tanya Arens

Hello!

I am trying to find an efficient way of filtering rows to include a number range including and between two different columns.

my task list has T-week start and end numbers, I would like the end result to have a user be able to enter a T-week number and see all "active" tasks for that week.

Using the example below, It is T-44 week, and I would like to be able to see the circled rows below.

I had been adding individual T-weeks to a "helper" column, but there are over 500 lines and run risk of not being accurate if there are T-week updates. Not sure if a formula would work to pull the numbers AND numbers in between in to the helper column, or a way to set filter options in a way that would get the desired result

Thanks so much for any insight!

UPDATE: I was able to use a textjoin formula in my excel output to get what i need, but didn't seem to work when entering into Smartsheet and replacing the cell numbers =TEXTJOIN(",",TRUE,SEQUENCE(R17-Q17+1,1,Q17,1))

Jgorsich

You just want a filter for the view, right? You can have multiple conditions in a filtered view.

Filtering for Tstart<=X AND Tend>=X seems like it should do the job for you for any value of X, they would just need to change the value of X for the week they want.