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.
Best Answers
-
Give this a try:
=COUNTIFS({Watchlist 20230615}, 1, {B Sub Date}, NOT(ISBLANK(@cell)), {PRD}, ISBLANK(@cell))
-
Thank you, Carson! Did the trick.
Answers
-
Give this a try:
=COUNTIFS({Watchlist 20230615}, 1, {B Sub Date}, NOT(ISBLANK(@cell)), {PRD}, ISBLANK(@cell))
-
Thank you, Carson! Did the trick.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!