Formula: Not in the last (x) days

A Rose

A Rose ✭✭✭✭✭

12/20/21 edited 12/20/21 in Smartsheet Basics

Hi,

What formula gives me the same value as the above filter?

Would need something like COUNT IF {Range 1} Is Not in the last (x) days

Thank you!

Tags:

Formulas

0 ·

Best Answer

A Rose ✭✭✭✭✭

12/20/21 Answer ✓

https://community.smartsheet.com/discussion/85904/formula-for-filter-not-in-the-last-x-days/p1?new=1

0 · Share on Facebook Share on Twitter

Answers

A Rose ✭✭✭✭✭

12/20/21 Answer ✓

https://community.smartsheet.com/discussion/85904/formula-for-filter-not-in-the-last-x-days/p1?new=1

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Date in Column Properties
Hello- Is there an alternative way to select the year if I use the Date in Column Properties? I'm having issue because when I want to choose year 2021, I need to click the left arrow multiple times just to reach the year I want. Is there a more efficient method to navigate to earlier years? Thanks
Why doesn't Automation Workflow, "Assigned To has been changed", work correctly?
Hi all, I would appreciate another set of eyes to review my workflow please. Here's the automation: I get the email, but it shows exactly how it is written above (yellow highlight). I was expecting it to show the name of sheet. I thought this was working correctly at one point but can't say for sure. I can't find any notes…
Update requests for multiple people, same row.
If 3 people receive an update request for the same row, will the update request disappear once the first person updates the applicable row? It does not appear that this is the case, but wondering if it should be?

woman with hands out and open

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

Watch video<