Last 30 days range
Hello,
I have looked through the forums that are currently open and could not find a formula that would fit my current needs.
I am using the following formula now:
=COUNTIFS({Pre Trip Completed}, <3, {System}, "ITCMW", {JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 8)
This formula is pulling data by month (8= August) which means I will have to update each of these formulas monthly and there are almost 1,000 of them.
How can I have this data pull from today and the last 30 days? I have already tried:
{Date}, <TODAY(-30)
Thank you in advance,
Kyle
Best Answer
-
I solved this.
If anyone is in the same boat:
=COUNTIFS({Pre Trip Completed}, <3, {System}, "ITCMW", {JBO Type}, "Overhead", {Date}, <TODAY(1), {Date}, >TODAY(-30))
Answers
-
I solved this.
If anyone is in the same boat:
=COUNTIFS({Pre Trip Completed}, <3, {System}, "ITCMW", {JBO Type}, "Overhead", {Date}, <TODAY(1), {Date}, >TODAY(-30))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!