I am looking who knows Apple Numbers well and could quickly make this spreadsheet work for us.
I need to update a spreadsheet from Google Doc to Apple Numbers because the formulas and functions do not pull through when it was exported.
1. Tab titled Transactions: Column B, Category. Needs to be connected as a drop-down list to the options on the Tab Categories > Category Name.
2. The Tab titled Profit and Loss needs to be connected to the Transactions tab. So for all columns there needs to be a search function that would find the totals from the Transaction tab for the corresponding items. For example, Revenue> Sales : would need to find a corresponding total amount and the accurate month from the Transactions. (This is a copy of the formula from the google doc : =if(isblank($F7),,SUMIFS(Transactions!$E:$E,Transactions!$B:$B,$F7, ARRAYFORMULA(MONTH(Transactions!$C:$C)),MONTH(G$4))))
If you have any questions, don't hesitate to ask via direct message!