I have established some Custom Properties for my projects (for Test Cases precisely) and would like to update the Excel spreadsheet to be able to import the from xls. I know this can be done by input the property ID, however it is not quite usable. I would like to create my own lookup inside the spreadsheet, in the style of other existing (for instance 'Importance'). Assuming I will have cust prop 'Difficulty' with values Hard, Moderate, Easy, I would like to have lookup list with these descriptive values, which would then be exported using correct IDs - may configure that in you Excel template? en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/456.aspxthreadId=456Radoslaw Rozkowinski (radoslaw.rozkowinski@gmail.com) I have established some Custom Properties for my projects (for Test Cases precisely) and would like to update the Excel spreadsheet to be able to import the from xls. I know this can be done by input the property ID, however it is not quite usable. I would like to create my own lookup inside the spreadsheet, in the style of other existing (for instance 'Importance'). Assuming I will have cust prop 'Difficulty' with values Hard, Moderate, Easy, I would like to have lookup list with these descriptive values, which would then be exported using correct IDs - may configure that in you Excel template? Tue, 18 Dec 2012 11:17:58 -05002012-12-21T20:13:54-05:00/Support/Forum/spiratest/issues-questions/456.aspxmessageId=867David J (adam.sandman+support@inflectra.com) You need to enter in the ID values in the current version of the spreadsheet I'm afraid. You could manually build a data-range and use a lookup. We may add this functionality to a future version of the Excel sheet.Fri, 21 Dec 2012 20:13:54 -05002012-12-21T20:13:54-05:00/Support/Forum/spiratest/issues-questions/456.aspx#reply867