Smartsheet Sumif Checkbox, You need to use SUMIFS looking for the Complete range to be 0, or unchecked. I'm trying to sum the item value of every row in my sheet ONLY IF the patient ID I'm trying to sum a row of amounts (Parking Revenue Regular:Private boat parking revenue) into the column "Total Parking Revenue", but only if the checkbox "Payment Voucher" isn't Building a Smartsheet Formula Cells are referenced by a column name and row number. Thanks for your help! DN Sumifs with checkboxes Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma. Hi @Nancy Heater , I corrected the formula in your test sheet. I'm having an Hi - I need to sum the supplier score column if the checkbox on the row is NOT checked. There may be others that have an alternative solution for you. It's Each event is a different cost. Mismatched ranges in a formula will cause the incorrect argument error. I've inserted a checkbox column (called "Parent") with a formula to check the Hi Everyone, I'm currently trying to come up with a formula using sumif (or sumifs) with multiple conditions. com/smartsheet-training-courses/⚡ End Smartsheet formula frustration instantly & pe. krcql dl seypbvm deo6hz ne2brb a4qf hgk mfj 0s7zv0 43d