Filter for next week/month tasks

Hi,

Smartsheet newbie here. I want to set a filter so I can just show tasks that have a start date less than a week (or month) from now. Is it possible to use some form of variable or formula in a filter condition so that it always returns a date say 7 days from now?

Thanks,

Ian

Find more posts tagged with

Construction

Comments

Tony Davidson - SmartSheet Certified User 2016

I would suggest you download this template and you can look for the type of formu that would apply to your requirements

https://www.smartsheet.com/solutions/smartsheet-formula-examples

Ian Pigney

Thanks Tony,

I'm pretty comfortable with formulas in cells in he sheet - it's the filter criteria I'm interested in. I was hoping you could use formulas or special variables of some kind there (something like [next week]) but it looks like you can't.

Your answer inspired me to figure out a simple way to do it - I'm embarrassed I didn't think of it before. I created a number column that calculates the number of days between the planned start and today ([Planned Start Date]x - Today()) and then filtered on that column for <= 7 or whatever value I wanted.

Thanks,

Ian