How can I use countifs to sort Modified date?
I am trying to create a dashboard to help me sort through our companies updates in emergencies, which they will submit through a form. Each section has a symbol of red, yellow, green, gray. I have the formula to summarize them by section. I am looking to pull how many reds based on time now. Since some incidents may occur & last more than 24 hours and Exec will want daily reports to summarize I am trying to create a formula to only pull the symbols within the last 24hours.
I am very new to this but this is what I have right now for a formula
=COUNTIFS({Activation Updates Range 1}, "red":{Activation Updates Range 11}, AND>=TODAY(-1))
Answers
-
So close! Just remove the "AND" from your formula:
=COUNTIFS({Activation Updates Range 1}, "red":{Activation Updates Range 11}, >=TODAY(-1))
-
It's still telling me unparseable?
-
Try this:
=COUNTIFS({Activation Updates Range 1}, "Red", {Activation Updates Range 11}, >=TODAY(-1))
The colon before the second range needs to be a comma.
-
Thank you that worked! Any idea if it's a day from the date or 24 hours?
-
It is strictly date based, so any submissions that have a date stamp of yesterday's date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!