COUNTIFS for Escalation Tracking

I am looking to create a formula that counts the how many times over the last 12 months escalations of a certain deal size occurred. Deal size is represented as range of AUM in text format. The current formula I'm using is

=COUNTIFS({Escalations Range 1}, "75M - 150M", {Escalations Range 2}, >TODAY(-365))

I created a formula to count all deals within the 75M - 150M range but when I try to introduce the date component I get errors.

See the attached screenshots referencing the columns.

Thanks for helping

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

Nic Larsen

Strange. Nothing jumps out in your formula.

If you just count dates - does that work or error out? Is that column formatted as a date type? Is there anything else in that column that is not a date? Do both cross sheet ranges match? That's all I can think of to check again.

chasedossa

Thanks Nic. I ended up using the AI feature and that seemed to work.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.