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.
In cell 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.
=if(today()=A2,'Invest. Summ'!B$6,B2)
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?
