Pull a List into a Dashboard

I am creating a dashboard to summarize the work being done across multiple different projects. One metric I want to include is a list of the program officers. I have pulled a list of all the project lead names and identified the duplicate values (when a project lead is assigned to multiple different projects), but now I am stuck on how to create an equation to pull a list of only the non-duplicates or the "1" values. Any advice?

This is the formula I am using to determine the duplicate values: =IF(COUNTIF([Project Lead Name]$1:[Project Lead Name]@row, [Project Lead Name]@row) <> 1, 0, 1)


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!