Excel have Conditional formatting option for highlight the duplicate values. Does this currently exist as an option for Smartsheets or could this be added?
Sign in to see the current vote count, add your own vote, or leave a comment.
Adding the ability to do conditional formatting by column, similar to how I would flag a column for duplicates in Microsoft Excel.
I have found workaround using Bing copilot, but I would like to have that feature out of the box
This would be really useful to have immediate functionality for this. There is a workaround where you use a helper column that is a checkbox that gets ticked using a formula that looks for duplicates. You can then apply conditional formatting on the rows that have the checkbox ticked. https://community.smartsheet.com/discussion/73270/formula-for-duplicate-entries/p1
Realise it's not ideal, but it's the best that can be done at the minute.
Is the functionality for real-time detection of duplicates on a roadmap, like how Excel auto-completes a cell if duplicate?
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.
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
