Calculating a percentage from sums in number columns

Platform discussions Special workflows & use cases
, ,
1

Greetings,
I am looking to calculate a percent completion from two sums at the bottom of 2 Numbers columns in the same board.

Example:
Column A is a numbers column containing the amount of each item I am expecting.

Column B is a numbers column to track the progression of what I have received of each item so far.

I want to take the total sums of the 2 numbers columns described and get a percent completion.

Does this make sense? The formula column is not quite what I’m looking for since it calculates a percentage of each item. Any direction/advice would be appreciated!

2

Hello, Yes, that makes sense. On a monday board the Formula column works row-by-row; it can’t read the footer “Sum” totals, so you can’t directly do sum(B)/sum(A) in a Formula column on the same board.

Here are ideas to try and to get an overall percent from the two column totals:

Option 1: Connect boards + rollup (most flexible)

  1. Create a tiny “Summary” board with one item (e.g., “Overall Progress”).

  2. On your main board, add a Connect boards column linking all items to that single “Overall Progress” item. You can bulk-link existing items and add an automation so new items auto-link.

  3. On the Summary board, add two Rollup (or Mirror with aggregation) columns that sum:

    • Column A (expected) → Sum

    • Column B (received) → Sum

  4. Add a Formula column on the Summary board:
    IF({Received Sum}=0 OR {Expected Sum}=0, 0, MIN(1, {Received Sum}/{Expected Sum}))
    Format it as Percent.

  5. If you want to see that overall percent on the original board, mirror this Formula column back to the main board (it will show the same overall percent on each row).

Option 2: Subitems with a parent “Totals” item (single-board solution)

  1. Create one parent item called “Totals” and make all your current items subitems under it (so A and B become subitem columns).

  2. Turn on “Show summary on parent” for the two Numbers columns so the parent shows their sums.

  3. Add a Formula column at the parent level that divides the two subitem-sum columns:
    IF({Subitems Received Sum}=0 OR {Subitems Expected Sum}=0, 0, MIN(1, {Subitems Received Sum}/{Subitems Expected Sum}))
    This gives you a single overall percent on the “Totals” parent item.

Hope some of these ideas help!