Filter for next week/month tasks

Ian Pigney

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 

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

Tony Davidson - SmartSheet Certified User 2016

Perfect!!