Portfolio Metrics Formula

Hi everyone,

I'm trying to calculate from two different columns on a portfolio summary and can't quite figure out the correct formula. I've gone through and tried many of the suggestions from here without any luck.

What I'm trying to accomplish: Count how many (blue) items are in "Health" column, but only if "Key Contact" column contains a specific name.

Please help! πŸ˜–

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!