Trying to ignore blank rows in a linked sheet

Hello,

Paul helped me previously to create the below formula which is working perfectly. I am however having one issue, when all the cells are blanked, it is revealing "sometimes". I dont need it to count the blank cell. If all the cells are blank, I want the result to be blank. I tried using isblank, but no result. Any help would be grateful. Not sure if this is because the formula is created in a linked sheet.

Here is the formula


=IF(COUNTIFS([Criteria A]@row:[Criteria D]@row, @cell = "N/A") = 4, "N/A", IF(COUNTIFS([Criteria A]@row:[Criteria D]@row, OR(@cell = "No", @cell = "N/A")) = 4, "No", IF(COUNTIFS([Criteria A]@row:[Criteria D]@row, OR(@cell = "Yes", @cell = "N/A")) = 4, "Yes", "Sometimes")))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!