Formula to remove duplicates in a column

I have a column Project in sheet with same value multiple times..would like to remove the duplicates and show only the unique values as under Result in dash board or report. Can any one advise the easiest way..thanks



Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Ash Radhakrishnan

    There may be a different way to achieve your goal, but this is what I'd do.

    I would add in a "helper column" with a formula and have a "Created Date" System column in the sheet as well. Then the formula in the Helper Column would flag the row with the newest date per-person. That way only one row per-project is flagged, and you can use that in a Report to pull the unique names.

    Like so:

    This would be the formula for the Helper Checkbox column for the sheet above:

    =IF(MAX(COLLECT([Created Date]:[Created Date], Project:Project, Project@row)) = [Created Date]@row, 1, 0)


    It says, if the MAX date, specific to the person in the Project column (using the COLLECT function), is the same as the date in this row, then check the box.

    Let me know if this makes sense or if you have any questions!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!