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
-
You would need a COUNTIFS.
=COUNTIFS({Health Column}, @cell = "Blue", {Contact Column}, @cell = "Specific Name")
Answers
-
You would need a COUNTIFS.
=COUNTIFS({Health Column}, @cell = "Blue", {Contact Column}, @cell = "Specific Name")
-
You're the best! Thanks Paul :)
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!