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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.