Please help with sumifs when the criteria is check boxes


I am trying to sum a column if none of the checkboxes are checked. I have 9 checkbox columns that need to be factored in. I can get one column to work, but when I start adding more columns it will not work. I think I am missing something simple because I am frustrated.

My single column formula is =SUMIFS([RMA request $]@row, [Adjusted RMA]@row, true)

I have changed the true to a 1 as well.

In the end, I just need the "RMA Requested $" to be in the last column if nothing is checked off.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!