I would like to highlight cells in a column that are duplicates
I have a sheet, that has lots of data, I would like to specifically highlight / conditional format a cell that has a duplicate somewhere else in the column.
I know how to do it in Google Sheets with a conditional formatting formula (=countif(A:A,A1)>1) but not sure how to make that happen in Smartsheet. Is it possible?
Best Answer
-
I found a workaround, add a separate column to do countif, and then did custom formatting based on that.
Answers
-
I found a workaround, add a separate column to do countif, and then did custom formatting based on that.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!