How to add test metrics based on multiple test case sheets?


Please help me with the following:

  1. To have multiple sheet in on grid like excel?
  2. How to create Test Metrics like how many pass, fail, defect count, defect status etc.. based on multiple test cases and defect sheets available in the smart sheet.




  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    If you have datamesh app, you can mesh all your sheets into one location and build a COUNTIFS formula. If you don't have datamesh, you would then just add multiple COUNTIFS together

    =COUNTIFS({Sheet 2 Range}, "Pass") + COUNTIFS({Sheet 2 Range}, "Pass") + ...

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner