Rally Software

Expand all | Collapse all

Excel Add-in: How to set a filter with a variable based on Spreadsheet Cell Value

  • 1.  Excel Add-in: How to set a filter with a variable based on Spreadsheet Cell Value

    Posted May 29, 2015 10:03 AM
    Hey,
    Scenario:
    I define my test cases in an excel spreadsheet and import them to Rally to the corresponding User Story. Only then, the TC ID is set. I would like to export that back to my spreadsheet in a way that requires minimum intervention (since I probably will have to share this with others).

    Problem:
    I am looking for a way to export the TC IDs filtered by the corresponding User Story (Work Product).
    Type: Test Case
    Order: Formatted ID
    Columns: Formatted ID
    Filter: (WorkProduct.FormattedID = "S55555" <-- the part that I would like to replace by {Value of Cell A2 from the Setup Tab}

    Is this possible?

    Thanks a lot  


  • 2.  Re: Excel Add-in: How to set a filter with a variable based on Spreadsheet Cell Value

    Posted Aug 12, 2015 10:56 PM
    You may have to write a VBA to do this, I think. Not possible to do this otherwise.
    http://www.excel-easy.com/vba.html
    Hope this is useful.
    Sesh