Unique data and sort row function

Options

Hi,

I have a customer base with one customer appearing 4 to 5times and have values across them. I want to create unique customers and represent their values in chart format. And every time a new customer is added, their value appears with the sorting Ascending or Descending. I have tried using Report with sorting function.

Please suggest how can I do.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!