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! :)