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

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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