How can I display unique lines only on a dashboard with 2 attributes?

Options
rachel1073
edited 12/09/19 in Smartsheet Basics

I have a dashboard/report where I want to show a list of our projects as long as the project name is unique, and the country is unique.

 

For example, in the attached image, I would want the lines highlighted in pink to not show, as they are duplicates of both project and country. I want it to ignore anything like flavour, or other attributes that I have in my data set. 

 

I'm using this formula to count duplicates of the project, but it ends up hiding when that project is happening in multiple countries.

=IF(COUNTIF(Project$1:Project1, Project1) > 1, 1)

 

How can I get this to work without the Pivot app?

 

Annotation (4).png

Comments