Filter by Week

Hi, Relative newbie here. Im creating a smart sheet for the maintenance planning and scheduling at my work. The idea is that once jobs are planned they can be added to the sheet, and with filters made set by week number IE week40....... Easy enough

The problem I am having is if a task duration is 3 weeks long as an example, it falls outwith the filter rules and is not shown.

Does anyone have any idea how to overcome this?


  • John Jonassen
    John Jonassen ✭✭✭✭

    You will probably need to make 2 series of filters, those that are started within your weekly date ranges and then those that are to be finished in the weekly date range.

  • I think what you are saying is what I already have in place to pick up the work being carried out in the week.

    The problem I am having is that if a task is 3 weeks long, It starts before the week in question, and finishes after it. Therefore the filter doesn't pick it up

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!