Question

Hey!
So I created a new table database today which is supposed to eventually become a pretty complex budget overview.

Here is to my problem:

In column 1 of the table I note down numbers, the second column shows a checkbox and the third column will be a formula.

If the checkbox in column 2 is checked, I want the formula in column 3 to return the exact same number that I noted down in column 1.
If the checkbox in column 2 is not checked, I want the formula in column 3 to return only a blank space.

So, I am pretty sure there must be some if-statement to achieve what I have in mind and I already know how to individually indicate the status of the checkbox or how to return the number by using a formula.
But I just can't happen to find a way to combine both so that the third column only shows a number if the second column shows a ticked checkbox.

If there is anyone who might have an idea how to get this problem fixed, I would deeply appreciate some help!

Thank you all in advance! :)

Answer 1

If I understand correctly you want to check if column 2 is checked, if that is true, then clone column 1 in column 3, if it is false, then nothing.

Try this Notion formula in Column 3.

if(prop("Column 2") == true, format(prop("Column")), "")