Sheets - calculation

[Peter Revay]

We have the Sheets app added in our Jira, and using this Sheets, I would like to calculate, like column A x column B = Column C. how can I achieve this?

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Peter Revay

Hannes from the JXL team here :)

You can't currently calculate values directly in JXL, although this feature (dubbed Formulas) is high up in our roadmap.

For now, what I would recommend is to use Jira Automation or an app like Scriptrunner to perform this calculation and write the result into a seperate field. This field can then be added to your JXL sheet, and will update if you change one of the "input fields". Many of our customers use this integration successfully, and we also use it internally.

Any other questions please let me know!

Best,

Hannes

[Peter Revay]

thank you

[Fabian Lim · Accepted solution]

Hi @Peter Revay

Welcome to the community!

Do you have the link to the app you are referring to?

Thanks

[Peter Revay]

https://marketplace.atlassian.com/apps/1224710?tab=installation&hosting=cloud&utm_source=jxl-docs&utm_medium=referral