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

Formula
Hi Community. I have what I believe is a simple formula question, but I have honestly just about everything. In short, I have a Sheet with an Assigned To Contact List column where they value may be a single person, or multiple names. I am trying to count the number of times per individual. Such as, I many time within the…
How can I change this Formula to leave the cell blank rather than #INVALID DATE?
Most of the other columns in my sheet only require the counting of days from a date in a different column. When the source column in the formula is not filled out the cell is blank. I am guessing it has something to do with it starting as "IFERROR". EXAMPLE OF A FORMULA THAT WORKS: =IFERROR(WORKDAY([Bldg Initial…
Workaround for triggering generate document workflow when any of the 380 fields I have change
I need a generate document workflow to run anytime one of them changes. I don't want to put in all 380 fields, I don't even know if it will let me add that many. It seem as if the "if any field changes" option is not available on the generate documents workflow, you have to select at least one field.

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