Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
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.
Perfect!!
