How to add test metrics based on multiple test case sheets?
Hi,
Please help me with the following:
- To have multiple sheet in on grid like excel?
- 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
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives