Formula to not Count Checkbox
Options
I am working on building a SUMIFS formula to not count a certain row if a certain checkbox is checked in another sheet. I already have it counting everything if the criteria is correct, but having trouble adding the "NOT" if the checkbox is checked.
Thanks,
Kris
Answers

If a checkbox is checked, the program reads that value as "1". If it is unchecked, the value is "0".
In your SUMIFS, you can say if the box is checked perform action A, otherwise perform action B:
=SUMIFS([checkbox]@row=1, Action A, Action B)
Does that help @Kris Guthier ?

Thanks Amber, but I already have an @row for it to pull certain information as it's pulling specific type of projects.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!