Sparrow Plugins

monday.com apps

Sparrow KPI Formulas

Spreadsheet-style KPI formulas on your dashboards

Made by Sparrow Plugins, India. Support: monday-help@sparrowplugins.com (a person replies within 2 business days).

In monday marketplace review. The install link appears here once it is approved.

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.

Works as: board view, dashboard widget.

How to set it up

  1. Install the app from the monday marketplace and approve the permissions it asks for.
  2. Add the widget: open a dashboard, click Add widget, choose Apps, then KPI Formulas, and pick your boards.
  3. Click Edit KPIs, give the KPI a name and write a formula, for example COUNTIF({Status}, "Done") / COUNT().
  4. Pick number, percent or currency. On Pro, set the amber and green thresholds so the card shows its colour.

Plans

FreePro
Metrics2Unlimited
Boards1Unlimited
Thresholds0Unlimited
PriceFreeUSD 12 a month, or USD 10 a month billed yearly

Prices are in US dollars per monday account and are billed by monday. Tax is added where it applies.

Permissions it asks for

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).

Privacy · Terms · Support