Using a checkbox to countif

michael.vanhuss
michael.vanhuss ✭
edited 12/09/19 in Smartsheet Basics

I am trying to count based on 2 criteria if checkbox is checked. So far it only returns a zero value when the checkbox is checked. Here is what I have...

=COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, "true", {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review Total Loss Tes Range 3}, Client3)

Where tes range 1 is the checkbox and range 2 and 3 are the criteria. Any thoughts? What am I missing?

· Share on FacebookShare on Twitter

Comments

  • Brian W
    Brian W ✭✭

    Checkbox values are 1 and 0. Try this:

    =COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, 1, {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review Total Loss Tes Range 3}, Client3)

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video