How to calculate 2 condition from 2 different column and link it to another sheet


Hi I would like to calculate my current sheet records with 2 different condition which was "on going" at the same time it is an "Valid Issue"

Both "on going" status, and issue type "Valid Issue" is from different column. How do I manage to calculate the on going cases with valid issue only, and I would to calculate them from a new sheet.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!