Help w/multiple column criteria summary report
Answers

=IF(OR([1st Column]@row = "Yes  Defect Remediated", [1st Column]@row = "No  Fail"), 1) + IF(OR([2nd Column]@row = "Yes  Defect Remediated", [2nd Column]@row = "No  Fail"), 1) + ..............
Basically you are going to want to use this to populate a if true:
IF(OR([Column Name]@row = "Yes  Defect Remediated", [Column Name]@row = "No  Fail"), 1)
Then you are going to write a second one for the second column, a third one for the third column, so on and so forth. Then you can add them all together.
=IF(....., 1) + IF(....., 1) + IF(....., 1)
You would get a 1 for every column that is "true" and since you are linking together with the + all of those 1's will be added together for that row.
Once you establish that for each row, you can run your metrics on this formula column.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!