What smartsheet formula should I use to get the distinct value/s without changing the delimeter?

Elena Misa
Elena Misa ✭✭
edited 06/13/21 in Formulas and Functions

Hello. Need help on this. I've attached a sample below. I need to get the distinct Consultant name based on match performance rating column. But it gives me duplicate Consultant Name if matches the Performance Rating. Is there any other way to automate the consultant distinct name without changing the delimeter?

Performance Rating % should be ranked from highest to lowest and should match distinct consultant name.

Thank you & Regards,


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Elena Misa

    Hope you are fine, could you please share the formula that you are using and an excel copy of your sheet contains sample data  (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    PMP Certified


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!