formula help

Rebecca S. 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