Counting blank rows in the denominator as nested formula
Hello,
I have the following formula which is working well:
=IFERROR((((COUNTIF(Status:Status, "Green")) + (COUNTIF(Status:Status, "Yellow"))) / ((COUNTIF(Status:Status, "Red")) + (COUNTIF(Status:Status, "Green") + (COUNTIF(Status:Status, "Yellow"))))), "")
I need to also COUNTIF the rows are blank under the 'Status' column as part of the denominator (highlighted bold) in the denominator. The blanks must however be counted if another column, "Name" is populated.
Thanks in advance.
Vinton
Answers
-
Hello @Vinton Douglas,
Would adding =COUNTIFS([Status]:[Status], ISBLANK(@cell), [Name]:[Name], ISBLANK(@cell) = false) in to your current formula give you what you are looking for?
I have added it into a demo below as an example.
=IFERROR((((COUNTIF(Status:Status, "Green")) + (COUNTIF(Status:Status, "Yellow"))) / ((COUNTIF(Status:Status, "Red")) + (COUNTIF(Status:Status, "Green") + (COUNTIF(Status:Status, "Yellow")) + COUNTIFS(Status:Status, ISBLANK(@cell), Name:Name, ISBLANK(@cell) = false)))), "")
I hope that is helpful to you in someway,
Protonsponge
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!