Sign in to submit new ideas and vote
Get Started

conditional formatting for Duplicate Values

Cthor
Cthor ✭✭
in Smartsheet Product Feedback & Ideas

Excel have Conditional formatting option for highlight the duplicate values. Does this currently exist as an option for Smartsheets or could this be added?

Tags:
Share on FacebookShare on Twitter
11
Up
11 votes

Idea Submitted · Last Updated

Comments

  • Krzysztof Wroblewski
    Krzysztof Wroblewski ✭✭✭

    I have found workaround using Bing copilot, but I would like to have that feature out of the box

    Krzysztof Wróblewski

    Smartsheet Enthusiast

    · Share on FacebookShare on Twitter
  • scWarrior90
    scWarrior90 ✭
    edited 04/14/25

    Hello - looking for a way to highlight duplicate values in a single column, dropdown style, with a random number of entries. Basically, we receive a document from several vendors, this document contains a random number of lot numbers. These lot numbers are pasted into a column as dropdown with multiple selection allowed - this is used to get a count of items in the cell. We need to analyze all items in each cell to see if there are any duplicates. If duplicate are found, then we have a problem as lot numbers should always be unique.

    Any ideas are appreciated.

    · Share on FacebookShare on Twitter

Categories