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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives