I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.
- First formula pulls/copies the Scenario ID from the Tester sheet to the Defect Sheet. This is my original formula that is not working: =IF({TSADefectReviewStatus}@row ="Defect Confirmed", {TSAScenarioID}@row ,"")
- What is wrong with this formula?
2. The second half of my approach was to INDEX and Match the Scenario Name and Scenario Description based on the Scenario ID
Open to suggestions if there is an easier way between two sheets to get the same results.
Thank you in advance!
