Can If-Then Logic be used in Confluence tables?

Josh Gilbert May 29, 2015

We're using Confluence to communicate test results between group members. If a numerical value below a certain threshold (i.e. <1) is entered in Column A, then Column B should automatically register this and "FAIL" should appear in that column (if >=1, then "PASS", etc).

Is this sort of logic creation possible in Confluence data tables?

4 answers

1 vote
Katerina Rudkovskaya _Stiltsoft_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
November 29, 2022

Hi guys,

I’ve just come across this old question, so for other community members who may be interested in the topic let me mention our app – Table Filter and Charts for Confluence.
The described case can be achieved with the help of the Table Transformer macro. The macro allows you to scan the required column and set different values (statuses, text) based on the cells’ contents into another column. You may check here for an example.

Furthermore, your table can be filtered by this newly created column with statuses with the help of the Table Filter macro.

Besides, you may also try the Table Spreadsheet macro to get even more Excel-like functionality in Confluence.

Our team will be happy to organize a live demo for you – please book a suitable time slot here and invite your colleagues.

0 votes
CelesteCS June 3, 2016

Hello!

For any calculations in Confluence, including any manipulations with table data, you may use CelesteCS Math for Confluence.

It supports logical functions, such as IF, SWITCH, AND, OR and other.

There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.

Thanks!

0 votes
Davin Studer
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 1, 2015

There are a couple of commercial add-ons in the marketplace that will give you spreadsheet-ish functionality and could achieve this. You could also embed a Google Spreadsheet and get much of that functionality for free. But if you don't want that data on Google's servers then that may not be an option.

https://marketplace.atlassian.com/plugins/com.playsql.playsql-plugin

https://marketplace.atlassian.com/plugins/com.valiantys.spreadsheets

0 votes
Bob Swift (personal)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 30, 2015

Create a user macro and put your logic in there.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events