I have a Google sheet to track my investments over time. The sheet has one tab that tracks my current position as of today.
I'm trying to build a separate sheet to track my investments historically.
A2, I have a specific date (e.g. 1 Jan 2020), and in cell
B2, I have the following formula which should lookup my total summary position on another worksheet.
The formula works fine, however after that date, it wipes the value to 0 instead of keeping it as
B2 (I setup the sheet so it can do circular references).
How can I set it up so it doesn't wipe it away on other dates?