Google Sheets Named Functions and Template Library Plan
Create reusable formulas and templates for a team.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Plan a small library of reusable tools for my team's Google Sheets. Tasks we repeat: [REPEATED_TASKS]. Formulas people struggle with: [HARD_FORMULAS]. Number of users: [USERS]. Propose named functions (if available in our account [VERIFY]) with name, arguments, purpose and formula, plus a set of templates. Give one sample entry in full, with the documentation text a user sees, an example and a test case, using an invented task such as calculating working days between two dates. Compare named functions, named ranges and add-ons and say when each fits. Suggest a naming convention, an owner, a change log, and how to retire a function. Governance: who may add a function, how it is tested (typical and edge cases, review by a second person, documentation), and how users are told about changes. Pilot with two users and a feedback form, with success measures. Say when the plan is too heavy for a small team.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.