Need unique data line

Options

Hi team,

I have multiple duplicate date rows in my tracker but i need a single line for each date.. how's possible ?

need single line for like below

27-oct-2020 : CTMC-RC2/2015/WPTA/201400772K

13-feb-2021 : CTMC-RC2/BLP/2017/WPTA/201400772K

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Yashwant Singh

    Hope you are fine, please try the following formula:

    =JOIN(DISTINCT(COLLECT(Code:Code, Date:Date, [Unique Date]@row)))

    the following screenshot shows the result:


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

  • Yashwant Singh
    Options

    Hi @Bassam Khalil ,

    all good at my end...thanks.!! hope also the same at your end ..

    you can find unique value but how can i add unique rows in my summary / report page.

    actually working on a dashboard, I have some data in which data rows are duplicate (shared image to you), and create report only for 1 single row data..

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    @Yashwant Singh 

    Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

  • Yashwant Singh
    Options

    Please check below.. based on CITQ Date and CITQ Query, need only one row for each query..


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    @Yashwant Singh 

    Did you have in your sheet the "created date" Or "modified date" column?

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

  • Yashwant Singh
    Options

    no "created date" Or "modified date" column

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 06/10/21
    Options

    @Yashwant Singh

    you can use the following formula and change the index row number to collect the DISTINCT value from each group:

    1- Create a helper column contain series of numbers from 1 to "the number of the unique values you have "10 for example".

    use the following formula for each column

    CITQ-Unique =IFERROR(INDEX(DISTINCT([CITQ Query]:[CITQ Query]), series@row), "")

    CITQ Query-Unique =IFERROR(INDEX(DISTINCT(CITQ:CITQ), series@row), "")

    the following screenshot shows the result:


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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!