Budget Tracker Template - Where should I set the total planned budget?
I am trying to set the monthly budget for my accounts in this template:
However, I can't find the cell that I should fill with the planned monthly budget.
Every time I refresh the query it deletes cell C44 (Configured account budget)
Please advise.
The account and budget list that starts on row 44 on the template is tied to the query that pulls the data automatically using the specified account. If you would like to change that or add more accounts, please click on ‘Manage queries’ from the Supermetrics menu. That opens the hidden ’SupermetricsQueries’ tab which contains list of all queries in the file. Click on each query/row and open Supermetrics sidebar so that the query information appears on the sidebar. Click on 'Modify' to load the details and add/change the accounts in ‘Select accounts’ section and click on 'Apply changes' to re-run the query