How to get distinct column from source sheet into report.


I am creating a report. There is list of carriers in source sheet. I want to bring distinct carrier name into my report. I checked it is 126 in total. what I did I just copied and past distinct carrier but If someone add new it wont show I believe.

How can I bring in my report. If someone add a new carrier then it will add to my report in real time.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!