Question

I have made this Notion template to track my trades but I need to manually add the new Balance after every trade.

Is there a way to automate this without losing % per trade I made?

I will send screenshot

Thx in advance

Comments

Please dedicate at least 5 minutes to ask your questions, so it is possible to understand your needs, the problem and the solution you are looking for.

I made a Notion template to track my trades.
I have a column where I enter a number.
I have another column where I enter a text.
I have another column for this other thing.
I want to do this calculating the column 1 and 2.
The problem I have is this.
And I want to have this result.

The more time you spend elaborating your question, the better answer you will get, otherwise we have to imagine what you actually need and that is impossible.

---

Okey verry sorry about that, I'm new to Notion
So my problem is I want to fill in a number from the same table database from the previous row of another property.

I have the property "Starting Balance" where I want to fill in the number from the previous row of the property "Balance"

I know relations and rollups can be used for different databases but what about the same database just another row (the previous one) from another property.

Thx in advance!

Answer 1

Ok, now it is clear what you need and you can do it with a simple Notion formula. What is not clear enough is why you need 2 columns with exactly the same information.

Create a new formula property called Starting Balance and use the following.

prop("Balance")

That will show what you have in the Balance property as you need.