COUNTIFS , based on previous days - not including current day
SkiPatrolScott
✭✭✭✭
my current formula is
=countifs(field:field, (@cell > TODAY() -7),….. or (@cell> TODAY(-7)…this comes back with a total that included today. Is there a way to count the seven days prior but not count the current day in the formula?
Answers
-
If I understand your question correctly, this should work:
=COUNTIFS(field:field, @cell < TODAY(), field:field, @cell >= TODAY(-7))
-
=COUNTIFS(Date:Date, @cell < TODAY (), Date:Date, @cell >= TODAY (-7)), Activity:Activity,@cell= "Violation")
The field name is Date
comes back #Unparseable
-
There is an extra closing paren, try this:
=COUNTIFS(Date:Date, @cell < TODAY (), Date:Date, @cell >= TODAY (-7), Activity:Activity, @cell = "Violation")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…
- Is anyone able to help with the formula to Index Match the SO Number column and return the lowest date listed in the "finished date" column into the "first date" column? I can make it work when select…