Hi @randy, why does this particular sheet trigger the attached notification as soon as I add it to my own?
Google has made some changes that are much stricter about any functions that reach outside of the spreadsheet.
Most often the issue is a url pulling in an image like the Tiller logo.
Google is being extra careful because conceivably these URLs could maliciously dynamically include content from your spreadsheet. There are several other functions in addition to IMAGE() that Google now flags.
Ok, thank you for elaborating on that.
The notification appears when I add your template and disappears when I remove it.
From your response, I’m now seeing that Cell N1 within your template is showing #REF! while linking to an image file, while the screenshot on the community page for your template shows a logo should be appearing in that cell.
Deleting the link within Cell N1 clears the warning flag.
I’m now comfortable proceeding without the linked logo since it clears that notification, but should the link in Cell N1 within your template be changed given the “Spending Trends” tab shows a linked logo in Cell B1 without also triggering a warning notification?
I’m not sure which version of the Spending Trends you have but, to support this change, Google has implemented a way to embed logos recently so that there is no external communication when drawing images.
Looking now, the installed version is 1.02.
I presume most Tiller users are on consumer Google Accounts whereas I’m using G Workspace, but I’m not sure that would have anything to do with this because linked logos elsewhere within the file are not also causing that flag.
The Spending Trends has a bunch of images in the “Set up tips” section that we’ll need to clean up @randy