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

Why are my Task Rows expanded every morning?
I've been using smartsheet for a few years now and never had this issue before, but starting this year, every morning when I go into one of my project sheets at the start of my work day they are ALL expanded. I have parent and child tasks that are 100% completed a year ago that are now suddenly expanded every morning. So…
Where are the AI (formula generation) icons now? 2025
Before, I was used to seeing the AI icon listed on the right side menu, at the bottom. where is the AI formula generator icon now in 2025?
Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?

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