How to make a cell display 1 if a box is checked

Aaron Kennedy

Really simple code I can't figure out, I just need code that changes the cell to a 1 if the "Submitted" box is ticked in another cell in the same row and display a 0 if unchecked.

This is for another sheet where I'm just gonna use SUMIF to add up all the 1's that appear in this sheet.

Shanky Paul

Below is the formula:
=IF([Submitted]@row = true, 1, 0)

Adam Costello

Alternatively, instead of SUMIF you could use =COUNTIF(Submitted:Submitted,1) to count how many boxes are checked.