Formula to exclude a cell


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?




  • Mike TV
    Mike TV ✭✭✭✭✭✭


    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
    Mike TV ✭✭✭✭✭✭


    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!