COUNTIF Checkbox Help!

Help!!! I'm trying to create a formula that counts a row if a column "A" value =X AND column B check box is checked.

I have tried the following and it does not work. Any suggestions?

=COUNTIF(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for Signature", @cell = "Proposal Development", @cell = "Proposal with Client", @cell = "Declined", @cell = "Under Revision", @cell = "Request Received/Documented", ([Proposal Team Project] @row, 0)))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!