Search the SheetSense formula library
search_formula_librarySearches 60 hand-checked worked examples of common spreadsheet tasks (lookups, SUMIFS, dates, text cleanup, arrays) and returns the formula with Excel, Google Sheets, SQL and pandas versions, pitfalls and a link. Use for 'how do I ...' spreadsheet questions.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"query": "<query>"
},
"name": "search_formula_library"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | What the user wants to do, e.g. 'lookup with two conditions' or 'count unique values'. |