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

sunil.pandey

Hi,

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.

Regards,

Sunil

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") + ...