Having issues using Distinct and Contains within a Countifs formula

Options

Hi, I'm trying to create a formula that counts the number of distinct "Funder Assigned Project Names" for all rows where the "Project Reference" column also has a partial match text match. I.E. I want to know the number of distinct "Funder Assigned Project Names" where the "Project Reference" contains the word "Touchet."

This is what I've come up but I am getting an #unpareseable message.

=COUNTIFS([Funder Assigned Project Name]:[Funder Assigned Project Name], DISTINCT(@cell)), ([Project Reference]:[Project Reference], CONTAINS("Touchet",@cell))

Thanks for any help!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!