Expand my Community achievements bar.

"Is/Is Not Unique" option for Reporting on Text-Based fields

Avatar

Level 5

11/22/21

My business area uses Projects that need unique names, as each Project is tied to a specific product. For us, when the same Product project is imported via Kickstart into our workflow it doesn't break anything - if we catch it we remove the extra and only one will go through the workflow. However, at the end of the season we then have a lot of open product projects that we need to circle back and see if they are duplicates or are truly missed. Right now, I just run reports of the projects and group by project name and investigate any of the groupings with more than (1). Having a "is/is not Unique" option when searching by project name (a text field) would be incredible as then I can search for just the offenders, similar to is/is not Blank.