What is wrong with my Formula? I want to do a countifs to count by deal stage within a date range.
Options
I am counting all of my deals in "Lease Negotiation" in the year 2023.
=COUNTIFS({Master Pipeline Tracker Range 1, "Lease Negotiating", >=DATE(2023, 1, 1), {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31))
Please let me know what I am missing here.
Answers
-
Your first problem is that Master Pipeline Tracker Range 1 doesn't have the } at the end of it. Your second problem is the DATE(2023, 1, 1) is where another range to evaluate is supposed to be.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!