COUNTIFS OR Function Error



I'm attempting to create a formula that will count the number of requests that are pending review. The column uses a drop down menu with three options, Submitted, Approved, or Declined. I'm trying to create a count in the Sheet Summary to count the number of requests that are still pending approval. The options that it looks for are "Submitted" or a blank cell.

=COUNTIFS([BLC Approval]:[BLC Approval], "Submitted", OR [BLC Approval]:[BLC Approval], "")

The above formula is returning an unparseable error. I suspect it has to do with the ending part of the formula. However, I can't figure out what to put for the second half in order for the formula to count a blank cell.

Thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!