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
-
@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, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
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
Categories
Check out the Formula Handbook template!