Multiple column count

D Johnson
D Johnson
edited 12/09/19 in Smartsheet Basics

Need help with a formula. It is to count total sites upgraded either to a interim or final result, but if the site has had an interim and a final it is only counted once.

I have 2 columns with check boxes and need to count as 1 if a cell is checked in either column. If both cells in the 2 columns are checked also =1.

so 

1+0=1

0+1=1

1+1=1

Comments