jira table in issue screen formatting cell dynamically and cell sum

matt_8qvq6s

 

I would like to see if there is a way in Jira to create a table in the issue screen that is able to highlight cell dynamically and calculate sum.

 

Pasam Venkateshwarrao

Hi @matt 

Welcome to the community,

Yes this can be possible through Add-on

 Table Grid Next Generation for Jira Cloud, This features  includes, such as calculated cell values or conditional cell shading. If you are looking to get as close as you can to an Excel-like table, this plugin is likely your best bet.

Depending on what your specific use case is, you can also take advantage of Wiki-markup tables if you just need the "look" of a table without any advanced functionality. However, there are some implications for your Jira instance  you should be aware of if you choose to change the renderer for a custom field.

To do this, you will need to create a custom field and then specify the field's behaviour:

1. Create a multi-line text custom field and add it to the issue create/view/edit screen.
2. Create a new field configuration for this project:
   1. Select the Jira icon > Jira settings > Issues.
   2. Under FIELDS, select Field Configurations to view all your field configurations.
   3. Click the Add Field Configuration button to open the Add Field Configuration dialog box.
   4. Complete the Add Field Configuration dialog box:
      
      
      • Name — enter a short phrase that best describes your new field configuration.
      • Description (optional but recommended) — enter a sentence or two to describe when this field configuration should be used.
   5. Click the Add button to add your new field configuration to Jira. Once you have added your new field configuration, you will be taken directly to the View Field Configuration page, where you can modify the field behavior of the new custom field in your new field configuration.
3. In the View Field Configuration page, find the custom field you created and click on Renderers in the Actions column.
4. in the Active Renderer dropdown, select Wiki Style Renderer and click Update.

You can now use Jira's text formatting notation guide to place a table inside of this custom field, by editing the custom field value in an issue using the following notation:

||heading 1||heading 2||heading 3||
|col A1|col A2|col A3|
|col B1|col B2|col B3|

 

Hope this helps