Adding the ability to do conditional formatting by column, similar to how I would flag a column for duplicates in Microsoft Excel.
Sign in to see the current vote count, add your own vote, or leave a comment.
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?
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.