...
This feature is available on all worksheets. If you import issues to sheet1, automatically, it will be available also in sheet2, sheet3 etc., even if you didn’t fetch any issues there.
Import
| Info |
|---|
Work on already fetched issues or import issues, without displaying them on worksheet. |
You can work on already fetched issues or import them, without displaying them on the worksheet. We will use the templating build-in import.
...
Start by selecting filter (1) from the dropdown list, if needed you can change default limit of fetched issues (2). When you click Import (3) button, issues will be fetched in background and you will unlock new “Template” section.
...
| Info |
|---|
Build a template using prefixes prefix and field IDsID. Select an Excel excel cell and use ‘Set Variable’, after choosing an when you choose issue and then use ‘Fill’ action. It , it will change variable to into value from the chosen issue. You can use multiple variables in one 1 template. , ‘Fill’ option works work on selections selection and fills out all variables (with values) that are matching current prefix. If you want to reset revert changes (filling variables) use the back /arrow button. |
To build a template you need to have some building blocks like variables, which will be filled with data of the selected issue.
...
manually, by typing it into desired celcell
by copy & paste the field ID with prefix, from the field section: https://psc-software.atlassian.net/wiki/spaces/ECSD365/pages/2412445711/Visible+Fields#Checkboxes%3A-Field-ID%2C-Prefix into cell
with ‘Set Variable’ button, which will insert variable into currently active cell
select field from the dropdown list
in the worksheet select cell, where you want to insert variable
use ‘Set Variable’ button
...
To reverse template fill, use the back ' → ' button → it will show variables again, then just chose next issue and use the fill option
...