If and checkbox

Setting the result to 0 will just show an empty checkbox. (1 = checked, 0 = not checked). If you want display an actual 0, add quotes around the zero in the formula Atus suggested, like this: 

=IF(Checkbox_column1, Value_column1, "0") 

Dimitris,

What I first see is that the syntax of your IF formula is wrong, it misses ", 0" (the "else" part) from the end. 

• Syntax: IF(logical_test, value_if_true, value_if_false)

Check out Smartsheet help for further info: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas#logic

If you still have problems, please copy the formulas you use in each related colunn here in the discussion and we'll try to help. 

Dimitris,

Can you elaborate on "a little more manual"?

Craig

So 5 columns

A Expenses Due - manual entry

B Incomes - manual entry

C Expenses Paid - manual entry?

D Remaining Expenses to be paid - = A - C

E Check box Paid in Full 

Are you trying to populate C when the checkbox is checked but not when it is unchecked?

Craig

If you add a formula in column C, as soon as you enter data* then you have overwritten it.

I interpret the process as 

A - total to be paid

C - might be partial payment (you want to enter an amount

E - check box for 'just pay it off' and save typing.

but that won't work for the reason stated above.

Craig

Dimitris,

At the simplest, I would just type into column C instead of trying to save a few keystrokes.

From the images you provided previously, I don't see any dates or interrelation between the rows. Is there?

If there are, you might try to think vertically instead of horizontally.

row 1 - summary row

row 2 - expense row

row 3 - payment row #1

row 4 - payment row #2 (if needed)

etc...

for each expense.

I gotta say that if I look at your images, they are mostly Greek to me.

https://en.wikipedia.org/wiki/Greek_to_me

When you refer to the 'balance' do you mean remaining to be paid for each specific expense?

Craig