Formula Help

Rebecca Wilhelm

I'm trying to count if specific conditions apply. I'm having issues having the formula count if the date field is blank.

ss 1.JPG

This is my current formula:

=COUNTIFS({Project Clean Slate Case Management Range 6}, (@cell >= TODAY()), {Project Clean Slate Case Management Range 6}, ISBLANK(@cell), {Project Clean Slate Case Management Range 8}, ISBLANK(@cell), {Project Clean Slate Case Management Range 8}, (@cell >= TODAY()), {Project Clean Slate Case Management - Status}, "Hearing Scheduled")

Stefan

Hi @Rebecca Wilhelm,

also your screenshot is about filters and not about a formula throwing an error from a blank field, I think you may need to add error handling to your formula:

You may consider

https://help.smartsheet.com/function/isblank

or

https://help.smartsheet.com/function/iserror

Hope this helps

Stefan

Rebecca Wilhelm

@Stefan The formula itself is not giving me an error. I have a filter in the sheet (image I attached) that I'm trying to mirror in a formula. I'm having issues with having the countif apply for future "blank dates".