Using a Checkbox in a Formula

Hi there -


I have a formula =SUM(COLLECT({MASTER TRACKING SHEET Range 29}, { MASTER TRACKING SHEET Range 24}, "Arizona"))

that I want to incorporate a checkbox column {MASTER TRACKING SHEET Range 28} into.


So, I'm looking for the sum of range 29 where range 24 is Arizona and range 28 is CHECKMARKED.


Thank you!

Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @aecross For this one, you'll want to use the SUMIFS function, because it allows you to specify multiple criteria that must be true. Keep in mind that for SUMIFS, the range you want to sum always comes first in the formula, before the criteria ranges and criteria. I'm not sure why you have COLLECT in there, but you don't want it in this formula.

    =SUMIFS({MASTER TRACKING SHEET Range 29}, {MASTER TRACKING SHEET Range 24}, "Arizona", {MASTER TRACKING SHEET Range 28}, 1)

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!