I don’t recall making any changes to protected fields in google Sheets, but the Total Expense field for “This Month” in the Spending Trends tab is not working correctly. This is the formula in that field: =-sumifs(AG3:AG,AD3:AD,“Expense”,AC3:AC,false). Is this formula correct?
I used AI to find a fix by restoring the Spending Trends Template.
1 Like
Glad you were able to resolve the issue. I find that on occasion when something isn’t working as expected there is an issue in a different sheet.
1 Like
to clarify do you mean you used gemenai/chatgpt to see what was wrong with the formula or did you give the agent access to your sheet and have it scan to see what was wrong?
I did not give access to the sheet, just queried the AI. Not aware that I can give access to the sheet, wouldn’t want to anyway.