I want to add columns with checkbox ticked and return a number

Dan Harris

What would be the formula to calculate checkbox ticked and return a number 2 when checked 0 when unchecked?

Thanks

Mark Cronk

Hi @Dan Harris ,

Create a new column and insert this formula:

=iferror(IF([INSERT check box could name]@row=1,"2",0"),"")

Is that what you're looking for?

Mark

Mark Cronk

Hi @Dan Harris ,

Create a new column and insert this formula:

=iferror(IF([INSERT check box could name]@row=1,"2",0"),"")

Is that what you're looking for?

Mark

Dan Harris

Thanks Mark that worked 👍️