Sparrow KPI Formulas
Spreadsheet-style KPI formulas on your dashboards
What it does
Dashboards in monday can't run formulas, and the Numbers widget shows one calculation of one column. This widget lets you write the KPI the way you would in a spreadsheet, across one or more boards. Two examples: COUNTIF({Status}, "Done") / COUNT() gives a completion rate, and SUMIF({Stage}, "Won", {Deal value}) - SUM({Costs}) gives a margin.
You get SUM, AVG, MIN, MAX, MEDIAN, COUNT, COUNTIF, SUMIF, AVGIF and UNIQUE, plus IF, ROUND and ABS. Conditions can be text like "Done" or a comparison like ">=100". Each KPI shows as a number, a percent or a currency such as USD or EUR. Set two thresholds and the card turns green, amber or red. Higher or lower can be the good direction.
The formula box checks your syntax while you type. It also tells you which column it can't find. We never run formulas with eval. On big boards it reads 500 items per request and shows a counter, and you can add the same view as a board view on a single board.
Free: 2 KPIs per widget on 1 board. Pro ($12 a month): unlimited KPIs, colour thresholds and several boards in one widget.
How to set it up
- Install the app from the monday marketplace and approve the permissions it asks for.
- Add the widget: open a dashboard, click Add widget, choose Apps, then KPI Formulas, and pick your boards.
- Click Edit KPIs, give the KPI a name and write a formula, for example COUNTIF({Status}, "Done") / COUNT().
- Pick number, percent or currency. On Pro, set the amber and green thresholds so the card shows its colour.
Plans
| Free | Pro | |
|---|---|---|
| Metrics | 2 | Unlimited |
| Boards | 1 | Unlimited |
| Thresholds | 0 | Unlimited |
| Price | Free | USD 12 a month, or USD 10 a month billed yearly |
Permissions it asks for
boards:read: reads the columns and items of the boards picked for the widget to calculate the KPIs
Questions
How do I refer to a column?
Put its title in curly brackets, like {Deal value}. With several boards, {Sales::Deal value} reads only the Sales board.
Which column types work?
Numbers, formula, mirror, time tracking (in hours), checkbox (1 or 0) and anything with text, like status, dropdown, people and text.
What does a condition look like?
"Done" matches the label Done, ">=100" compares numbers, "<>Stuck" means not Stuck, "" means empty, and * works as a wildcard.
Who can change the KPIs?
Anyone who can edit the dashboard or board. View-only users see the cards but not the editor.
Who can see my data?
Only you and the people you share the board with. The app reads and writes your board through monday's API with your own permissions. We store only the app's settings, your plan and usage counts, never your item content. See the privacy policy.
How do I upgrade or cancel?
monday handles billing. Open the app, click See plans, or go to Administration, then Billing, then Apps. Cancel there at any time; the paid plan stays on until the end of the period you paid for.
What happens when I uninstall?
The app stops at once, and we delete everything we stored for your account right away (at the latest within 10 days).