Formula to count # if blank or date in the future

sjmcdonald

Looking to count the total number of either blank or dates in the future - here is the formula that works to show blanks, but need to add is blank or todays date

=IF(COUNT(CHILDREN()) > 1, SUM(CHILDREN()), COUNTIFS({Site}, BFS$1, {Department}, $Department@row, {VResults}, <>"NOT DETECTED", {RTW Date}, ISBLANK(@cell)))

Genevieve P.

Hi @sjmcdonald

No problem! You should be able to add in an OR Function to identify the two things you're looking for.

Try this:

=IF(COUNT(CHILDREN()) > 1, SUM(CHILDREN()), COUNTIFS({Site}, BFS$1, {Department}, $Department@row, {VResults}, <>"NOT DETECTED", {RTW Date}, (OR(ISBLANK(@cell), @cell >= TODAY())))

Cheers!

Genevieve

Genevieve P.

Hi @sjmcdonald

No problem! You should be able to add in an OR Function to identify the two things you're looking for.

Try this:

=IF(COUNT(CHILDREN()) > 1, SUM(CHILDREN()), COUNTIFS({Site}, BFS$1, {Department}, $Department@row, {VResults}, <>"NOT DETECTED", {RTW Date}, (OR(ISBLANK(@cell), @cell >= TODAY())))

Cheers!

Genevieve