I want to have, for example, the issue key, summary, assignee, and status appear in a single cell. Is that possible? I'm trying to duplicate what we used to have in Confluence before the new editor broke everything.
Hello @Robert Lauriston
You can achieve that with Text join formula
https://support.google.com/docs/answer/7013992?hl=en-GB
Best,
Arek 🤠 ☀️
How would that work with Jira Cloud for Sheets?
You can pull out data and then aggregate it https://support.atlassian.com/jira-software-cloud/docs/use-jira-cloud-for-sheets/ with formula.
What would such a formula look like? The Atlassian doc doesn't help me.
@Robert Lauriston
You can easily do that with the Better Excel Exporter as it allows customizing the export logic (format) for each field separately!
In this case, you should make the "key" field export a longer string that concatenates the work item key itself, summary, assignee and status. You can do that by editing the "field-helper.groovy" script.
Alternatively, you can introduce your own calculated field if you don't want to change the export format of the "key" field.
If you don't know where to start, just open a support ticket and we will help make sure you receive a working solution.
Thanks, opened a ticket.
It looks like you're new here. Sign in or register to get started.
