Is there away to only add a cell value to a report the first time it appears?

Acernea

I use a Smartsheet to allow multiple people to attached an invoice and ask for and track check requests? One of the most common rejection reasons, is there is an online payment option.

Right now, if its rejected there is a column for rejection reason, and if that it checked a report is created showing the column which contains the Vendor number.

I'd like that report to not include duplicates, so once the vendor number is on there it doesn't need to keep showing up. This is my first time asking a question, so am happy to provide additional information if needed.

SteyJ

https://community.smartsheet.com/discussion/112927/is-there-away-to-only-add-a-cell-value-to-a-report-the-first-time-it-appears

Create a helper column for checking duplicates =COUNTIF([Row data]:[Row Data], [Row Data]@row)

Now, in the report, set a filter to only show data where the helper column is =1