Skip to Main Content

Share your product feedback

Status Future consideration
Categories Reports
Created by Guest
Created on Apr 1, 2019

Perform calculations on data in columns

This is probably on a roadmap somewhere, but in case it's not and I'm brilliant: 

Currently, calculation columns allow us to apply equations across a row of a list report (e.g., if Feature A's due date is before today(), display text "Behind schedule.").

But we can't perform calculation on data in columns of that list report, as you typically could in a spreadsheet. 

Use cases:

  • Average the effort estimations in a column
  • Sum the resource cost for all features in this release
  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Dec 22, 2022

      Will you be adding this capability? It would be super helpful.

    • Taimur Ahmed
      Reply
      |
      Feb 3, 2022

      Ditto for summing up scores

    • Guest
      Reply
      |
      Apr 15, 2021

      Creating a "total" row that sums up all cell values in a column is extremely fundamental capability that everyone uses in Excel.

    • Bob K
      Reply
      |
      Mar 26, 2020

      I would propose a third possible use case:

      • The calculated column would be a running total based on another column

      This would be helpful for lists showing potential work with an estimate of effort to get to that point (to assist with gauging resource needs, etc.).