How do I identify the cell in a column that has a value NOT in the restricted list?
How do I find the offending cell?
I imported an excel spreadsheet to a smartsheet.
I converted a list of names column to a Contact column
I manually created these people in My Contacts and converted the imported text to Contacts.
I check the box to "restrict to list values only"
I get this message:
How do I find the offending cell?
Answers
-
Create a filter on the Contacts Column and compare it to what you imported you should be able to select the one not in your list you imported. Hopefully it will stand out easily.
-
Hi Karen
Unfortunately, I imported a few hundred lines where the same names appear multiple times. It does not easily stand out. I was hoping there was a smarter way to identify the cells with non-compliant content than to export and "eyeball" or vlookup the list. Perhaps this is an enhancement request.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives