Removing Duplicates from a Report



I have a sheet with many line items, some of which share some columns that have duplicitous information. I would like to pull a report from that sheet to display certain information on a dashboard and, ideally, within the report, run a conditional format to remove the duplicate line items.

I am also reading up on the INDEX and COLLECT functions as it appears they may allow me to "summarize" information into another sheet which I can then run a report on for use in my dashboard. But I am having trouble understanding and implementing the INDEX and COLLECT functions.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!