COUNTIFS, ISBLANK, NOT(ISBLANK)

Deb W

Hi...I want Smartsheet to count a row if it meets three conditions: the "Watchlist" box is checked, there IS data in the "Beacon Submission Done" column and there IS NOT data in the "In PRD column."

Current formula is throwing Invalid Argument Set error:

=COUNTIFS({Watchlist 20230615}, 1, NOT(ISBLANK({B Sub Date})), ISBLANK({PRD})).

What am I missing? Appreciate the help.

Carson Penticuff

Give this a try:

=COUNTIFS({Watchlist 20230615}, 1, {B Sub Date}, NOT(ISBLANK(@cell)), {PRD}, ISBLANK(@cell))

Deb W

Thank you, Carson! Did the trick.

Carson Penticuff

Give this a try:

=COUNTIFS({Watchlist 20230615}, 1, {B Sub Date}, NOT(ISBLANK(@cell)), {PRD}, ISBLANK(@cell))

Deb W

Thank you, Carson! Did the trick.