Sheet Summary formula IF AND

Options

Hi, I'm looking for a formula for my Sheet Summary that will count the instances of checks in a checkbox column (CD), but only if the Status column does not show Complete.

I've made a start with this, but it's #unparseable.

=COUNTIF(AND(CD:CD, "1", [Status, "Complete")

Many thanks!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!