Column Formulas for Duplicates
Identifying duplicates with consideration of blanks
This is the formula I am using to identify duplicates and trying to omit blanks and it is giving me a syntax error, can someone please help?
Also, could I make this a column formula?
=IF(ISBLANK([Folder Name]),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0)
Best Answer
-
Hi @Katrina Liu
It looks like you forgot an '@row' at the beginning of your formula. This should allow you to convert to a column formula.
=IF(ISBLANK([Folder Name]@row),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0))
cheers
Answers
-
Hi @Katrina Liu
It looks like you forgot an '@row' at the beginning of your formula. This should allow you to convert to a column formula.
=IF(ISBLANK([Folder Name]@row),"", IF(COUNTIF([Folder Name]:[Folder Name], [Folder Name]@row) > 1, 1, 0))
cheers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!