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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!