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

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!