How do I calculate within last 60 days?
I am trying to calculate a sum of numbers in a column within last 60 days for a report and a dashboard.
I am trying to use this formula but it is not returning anything accurate.
=COUNTIFS(Date:Date, <TODAY(-60), [Total count]:[Total count], 1)
Total count is the column that I set up to count if the other checkbox column has a yes checked or not, if its a yes, it returns 1.
So basically I need to count only if its a "1" in the total count column.
Answers
-
Try this:
=COUNTIFS(Date:Date, AND(@cell >= TODAY(), @cell < TODAY(-60)), [Total count]:[Total count], 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!