I’ve created my own spreadsheet for tracking my net worth as well as financial goals. However, I have not found a good method to link the account balances on my sheet to a sheet that Tiller is updating through Tiller feeds. I have tried using the Net Worth sheet and Balance History sheet by typing “=[Tiller sheet cell]” into the cell on my sheet where I want the account balance to appear. However, every time Tiller updates it seems the order of accounts shifts and the numbers on my sheet are all messed up. Any guidance would be welcome. Thank you.
1 Like
You can add Tiller Feeds to up to 5 spreadsheets. Add it to the one you want. Or just add your custom work to the sheet you already have. There’s a great Net Worth tracker add-on sheet available in Tiller Labs.
When I link my sheet to Tiller Feed my accounts populate in three new Tiller tabs - balance history, transactions, and another one. Is there a way to link an account balance from the feed directly to a tab in my spreadsheet? Because it seems I am forced to link via the Tiller spreadsheet and each time the Tiller spreadsheet updates the accounts locations change on the grid.
Got everything working? You will need to do some tweaking depending what you have in your non-Tiller sheet to make it all work right. It’s hard to provide more specifics without seeing what you have. Keep reaching out until you are satisfied. Blake
Hi @ac123 ,
Let me give this a try.
If you want to get the Last Balance of any or all accounts, you will want to pull that information from the Accounts sheet. This Tiller sheet might be hidden but you can view it if you click the 4 lines (hamburger icon) on the button left of any sheet window, and select the account sheet.
As you noted, the account order might move around. That’s why it’s best to use a VLOOKUP() function to find the latest balance for the account you want.
On the Accounts sheet, if you “Account” names are unique, you could use this formula on any sheet in the spreadsheet to get your Visa Card account last balance:
=VLOOKUP("Visa Card",{Accounts!H2:H,Accounts!J2:J},2,FALSE)
Change Visa Card to any Account you want to get the last balance for.
If you want to find accounts by the Unique Acount Identifier, Account ID, or Account # listed in the Accounts sheet, then change the formula where it says Accounts!H2:H to the column letter of the column you want to use instead of Column H. So, Accounts!F2:F for example.
You can also put the account name in a cell on your other sheet, and use the cell reference in place of typing “Visa Card” in the formula.
Does that help?
Jon
2 Likes
Thanks, the VLOOKUP was the function I needed to make it work.
Much appreciated.
1 Like
I struggled to understand and use vlookup. Below are the exact strings I got to work finally (I’ve included my particular account strings as they are anonymous and give the exact syntax but obviously you must change the stuff in the quotes. also notice J100 is just far enough down to encompass all the data on my particular sheet. For some reason the brackets { } Jolo used above along with what I assume is a range syntax meant to include the entire column did not work for me.
vlookup has 4 inputs
1- the lookup string or # you’re searching for in the range
2- the range you’re looking in (Note Accounts! names the range as coming from the “accounts” tab)
3 - the column from which you are extracting (note this is the number of columns over from the start of the range in #1 above
4 - the word FALSE
WORKING lookup by unique account identifier in column F
=VLOOKUP(“Arduinoeidl Xxxx0632 - xxxx0632 (4B11)”,Accounts!F2:Accounts!J100,5,FALSE)
WORKING uses account# in column I
=VLOOKUP(“xxxx0632”,Accounts!I2:Accounts!J100,2,FALSE)
WORKING Uses Account name in Column H
=VLOOKUP(“ArduinoEIDL xxxx0632”,Accounts!H2:Accounts!J100,3,FALSE)
Update: I managed to simplify and specify the range as “all of column F thru all of column J” on the Accounts Tab.
=VLOOKUP(“Arduinoeidl Xxxx0632 - xxxx0632 (4B11)”,Accounts!$F:$J,5,FALSE)