Formula help to count a distinct field when a condition is met

Hello Smartsheet Community,

I'm trying to count the Distinct Project names in a different sheet's column when another column, PI Group, matches [PI Group]@row, but am getting an Incorrect Argument. Can you help me finesse this formula? Thank you!! Below is the formula that's not working and the data it's referencing. -kerri

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!