Cross-sheet formula with checkbox


Hello all,

I am trying to create a cross-sheet summary metrics sheet that counts data based on Status and whether a box is checked. If the "Project?" column check box is checked AND the Status is (for example) In Progress, I'd like this formula to count the number of instances. No matter what I try for the checkbox (true, 1, checked), I get UNPARSEABLE. Is this formula possible?

Thank you!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!