How to add a sequence number in confluence table

[Peng Chen]

Hi

I'm looking to add a sequence number in confluence table, it works this way:

1. User sets manually a sequence number in one of the column, use 1 as step
2. If user changes a number in the column, it will change all the numbers that's larger than the number in that column by adding one

example:

• I have a table with 6 rows
• I have a sequence column
• In the sequence cell of each row, I put 1,2,3,4,5,6...
• If I change 5 to 2, then 2 becomes 3, 3 becomes 4, 4 becomes 5, 6 stay not changed
• If I add a row and fill sequence column as 4, then the previous 4 becomes 5, previous 5 becomes 6, previous 6 become 7

Is there a way to have this functionality? This could be useful to prioritize tasks.

Thanks!

[Rafael Pinto Sperafico · Accepted solution]

Hi @Peng Chen ,

You should be looking at User Macro (Writing User Macros), where you can create a script to read rows and columns from a given table and manipulate its values accordingly.

Kind regards,
Rafael

[Peng Chen]

Thanks to both of you, I will look into it

[Davin Studer]

Functionality like this does not natively exist in Confluence. However, there are apps in the marketplace that give you spreadsheet functionality for Confluence. You could do that with a spreadsheet formula. There are also a couple apps that work with native Confluence tables and formulas.