I am new and trying to sum table columns and table rows. How do I set up field calculations to sum?

Frank Crocitto

I want to place simple Excel Calculations in my table Number Columns and Rows to Sum up and down, and across?  I do not see this in any documentation.  Help

 

Can table work tasks be set up as DEPENDENCIES with tasks within a table and across tables?  Help again

 

Thank You

Aliaksei Mikhailau {Stiltsoft}

Hello Frank,

there are no native calculations functions in Confluence tables, so you need to look for a suitable app in Atlassian marketplace. And our Table Filter and Charts for Confluence app can be right what you need to make calculations.

With the help of our Table Filter macro you can use total columns and rows in the standard Atlassian tables. If you need more Excel-like view and functionality, please try our Table Spreadsheet macro.

I'm not sure if this is your case, but you can create a Gantt chart for your tasks and set dependencies between the tasks in it. Also, with the assistance of the Table Excerpt/Table Excerpt Include macros it is possible to merge similar tables from different pages in a report (dynamically changed when you change tables on the original pages) and display it on a summary page.

This is only a part of the many functions Table Filter and Charts provide, so the app is paid. However, Cloud version is available for free for companies with up to ten users.