Formula to exclude a cell

ESUBIA

Hello,

I am using Smartsheet to create a scorecard. There is an area where I would like to be able to exclude the cell from the count if it is blank. The current formula I have is this:

=IF([17. Voicemail - Follows script accurately]@row = 64, "Pass", "Fail")

How can I add so that if it is blank it does not count that cell?

Thanks,

Liz

Mike TV

@ESUBIA

The COUNT, COUNTIF, COUNTIFS functions won't count blank cells. Will that help you any? I'm a little confused as your formula isn't one that would count anything unless the 64 was a value that was counted.

ESUBIA

Hi Mike TV,

Let me give you more information. I have a series of columns that are being used to provide scores in different sections during a phone call. I build a report to pull an average of that score as multiple calls are scored. I want to put in a formula that will not affect that score when a voicemail is selected. I added automations to auto calculate a score of 0 or the full points for the other cells if voicemail is selected. The issue is I have a mid score let's call it a 2, if a 2 is selected then the cell is left blank and it fails the voicemail section. I may have posed the wrong question initially, but I think my issue revolves around that cell.

Mike TV

@ESUBIA

Sorry but I'm unable to picture what you're describing. I think you'll need to show us the sheet and formulas you're using to be able to assist you. Just remember to block out any sensitive data.