Formula Help Please!

Hey there Smartsheet Community!

I'm fairly new to Smartsheet and have only been using it for about a year. I'm trying to build this formula and it keeps returning "0", which is not accurate. What am I doing wrong?

=COUNTIFS({Constat Range COMPANY}, "AHI", {Constat Range STATUS}, "closed", {Constat Range SCHEDULED CLOSING DATE}, >=DATE(2022, 12, 31), {Constat Range SCHEDULED CLOSING DATE}, <=DATE(2023 / 2 / 1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!