formula help

Rebecca Wilhelm

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?

help.JPG

Thanks!

Mark Cronk

Hi Rebecca,

Try =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}, AND(@cell >= TODAY(), ISDATE(@cell)))

Confirm ranges and text in quotes are accurate. Hope it works.

Mark

Mark Cronk

Hi Rebecca,

Try =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}, AND(@cell >= TODAY(), ISDATE(@cell)))

Confirm ranges and text in quotes are accurate. Hope it works.

Mark

Rebecca Wilhelm

@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!