COUNTIFS Cross Sheet: 1 Column is blank and 1 Column is not blank
Hello,
I'm doing a master summary metrics sheet (in lieu of a summary sheet on the source sheet because I need to build graph charts in a dashboard).
I need to count blank cells in a specific column, but only if another column has text.
I'm using this formula:
Where Range 1 will indicate if a new submission has been received, and Range 3 will indicate if a group has confirmed the new submission. Right now, if I only count Blank cells in Range 3, it even counts the blank rows at the bottom of the sheet even though those rows don't have any new submissions - so this gives me a false count.
I thought I could course correct this by instead only count blank cells in Range 3 IF there was text in Range 1....but I keep getting #UNPARSEABLE and I feel like I've tried every combination of wording and parenthesis possible.
Any chance someone could help me understand what I might be doing wrong? I would sincerely appreciate it!!
Best,
Cyndi
Answers
-
I finally got it to work - realized I had one of my references pointing to a bad sheet / column. And I'm not able to delete my original post for some reason (only edit). I'm good!
-
Hi Cyndi,
Glad you got it working!
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!