how to create a filter when the delivery due date "in the next 30 days"

Shellie Whitmore

Shellie Whitmore ✭✭

09/07/21 in Smartsheet Basics

I'm creating a new filter with 2 rules and one is for "has a delivery date in the next 30 days"

All I am finding is actually dates on a calendar but not a way to select 30 days. What am I doing wrong??

0 ·

Answers

Marcelle Conradie ✭✭✭

09/07/21

I think you are looking for filter set on your date column with criteria - Date "is in the next days" - then enter "30"
date filter.JPG

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Notification Issue
Hi team, Was there an issue, or possible maintenance, that would have impacted notifications overnight last night (1/15 to 1/16)? My team saw delays up to 60 minutes on a couple of notifications that are typically sent within minutes, and at least one case where a notification still has not been sent. Notifications are…
Automation works when run manually, Doesn't run at all automagically.
Not sure what the secret to automation is but it's not working. What I'm trying to accomplish: Fill out form Data goes into sheet called Core Automation is triggered when new row is added which copies data to sheet called Bridge Rows 1-5 in Bridge contain default data I want to copy to Core Automation in Bridge is…
Date Formula Help Needed!
My current formula seems to count weekends and then also seems to count the day of as a day too - can someone help me rewrite this so days until due for 1/17/2025 would show as 1 and not 2, and then also skip weekends? Formula in case its hard to see below - =IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row), "")

Help shape the future of Smartsheet.
Share your ideas and feature requests.