formula help

Hey community,

I have this formula: =COUNTIFS({Project Clean Slate Case Management - Status}, OR(@cell = "Application Filed", @cell = "Waiting for Hearing Date", @cell = "Hearing Scheduled"), {Project Clean Slate Case Management Range 6}, (@cell >= TODAY()), {Project Clean Slate Case Management Range 6}, NOT(ISBLANK(@cell)))

I'm trying to mirror the attached image filter for metrics. It's not correctly counting. Where am I off in the formula above?


Best Answer


  • Rebecca Wilhelm
    Rebecca Wilhelm Overachievers Alumni

    @Mark Cronk Thank you! I had one of the text in quotes incorrectly written so both formulas now work! I love seeing how two slightly different logic thought processes get us to the same place! It helps me figure out other ways to think through it. I appreciate your help!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!