I have a Donor Advised Fund - an account committed to funding charities, with Fidelity. I know I can HIDE this account from my Balances sheet report (using the Hide feature of the Accounts sheet). I’d like NOT to hide its reporting (it’s nice to see its balance among my accounts).
But, I would love to change the value of the Balances top right corner “Net Worth” by deducting the value of this single account, as these monies are no longer mine (but irrevocably committed to charitable giving). Is it possible to alter the cell formula there to deduct that account value - and still have the balances listing reflect that account. I have that account in its own Group “Charitable” if that helps.
I have a formula in mine to show my net worth less the balance of some of my accounts. I use =D7-(VLOOKUP("Retirement",Balances!B8:D70, 3,false)) where d7 is my assets and retirement is my category name and return the value in the net worth spot. I wonder if something like that would be what you need. (Just FYI: I use straight quotes on the category name, but idk how to do that here.) Edit to update the formula format.
Begin and end the formula with a single backtick character, so the forum editor uses preformatted text. The backticks won’t show in your post, just what’s inside it using plain text.
e.g. `<formula>`
For a long formula, or block of code, use the forum editor Preformatted text option:
casilverthorn.96, thanks so much for replying; I only returned to town and appreciate your help.
In my circumstances, D7-H7- B25 [if B25 is the present cell location of the balance of the single account wished to be excluded] would work just fine - at present.
At ChatGPT’s suggestion, I successfully used:= D7 - H7 - IFERROR(VLOOKUP(“Charitable Giving Fund*”, B:D, 3, FALSE), 0).
For those like me that might need some big picture understanding, this is my understanding why you likely created a fancier formula, and why Chat suggested mine: The simple subtraction of the cell value sought to be excluded isn’t future proof - because this cell’s location might change as new accounts are added or removed from the Balances sheet.
I am not a power user so others may wish to edit / correct my understanding.
BTW, I also added the text “(excluding Charitable DAF)” to the Text “NET WORTH” at B5, so my Balances Sheet clearly tells me the Net Worth Value shown does NOT include the Charitable Giving Fund balance shown on the report. (Again, those funds are not my money any longer.) [Charitable DAF is the Group name of the Charitable Giving Fund.]
My formula is doing the same thing without the iferror portion if I am looking at it right. I use it to give me my liquid assets and net worth in separate cells and still see my full picture including retirement and non liquid assets and liabilities. Glad you found something that works for your case.
for replying; I only returned to town and appreciate your help.
