Assistance with #Unparseable error.
![System](https://us.v-cdn.net/6031209/uploads/userpics/650/n67RVONBT7K0D.png)
Answers
-
I have a similar issue where I have a Claim No column that I need to see where my duplicate entries are so I can review & remove them. I'm very new to this as well and I created a Duplicates column on my SS and set it up as a checkbox column. I entered the following formula (similar to yours above Andree) in the first cell of the duplicates column but it is showing #unparseable:
=IF(COUNTIF([CLAIM NO]:[CLAIM NO], [CLAIM NO]@row) > 1; 1)
Not sure what I'm doing wrong here?
-
@drichart flip that semicolon to a comma and it should work for ya!
=IF(COUNTIF([CLAIM NO]:[CLAIM NO], [CLAIM NO]@row) > 1, 1)Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
-
Thanks Kelly, that worked :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!