COUNTIFS, ISBLANK, NOT(ISBLANK)

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.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!