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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!