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))

Find more posts tagged with

Accepted answers

All comments

Julie Fortney

So close! Just remove the "AND" from your formula:

=COUNTIFS({Activation Updates Range 1}, "red":{Activation Updates Range 11}, >=TODAY(-1))

audrey.hart

It's still telling me unparseable?

Paul Newcome

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.

audrey.hart

Thank you that worked! Any idea if it's a day from the date or 24 hours?

Paul Newcome

It is strictly date based, so any submissions that have a date stamp of yesterday's date.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.