Merging A list to show unique value/identifier

Syed Muhafzal
Syed Muhafzal ✭✭✭✭✭
edited 05/29/21 in Formulas and Functions

Hi Smarties,

I am wondering if anyone could share some ideas on this.

I have a list of available products. Some of these products are repetitive in the list. For example

I would like to show a list of AVAILABLE products in the dashboard, but without the duplicated products. So ideally, it should be showing in the dashboard as below;

Product A

Product B

Product C

Product D

Since this product list is using an API from another source, it keeps throwing all product names so I will always get a duplicated list whenever it is being updated.

Question - is report the best solution to combine this? Does anyone have any experience with formulas or other features that you could recommend (that can b used frequently as new products will be updated from time to time?)



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!