Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Can If-Then Logic be used in Confluence tables?

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

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.


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.


0 votes

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.

Create a user macro and put your logic in there.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events