Formula not returning value as expected
Hi all and help!
I have made a formula to check a box when there is a duplicate ID Number in my sheet. But the box is getting checked when I add any new row to my sheet. I've tried to find where I'm going wrong and can't seem to find it.
Can someone with fresh eyes lend a hand?
Here's a snippy of what I have going on:
Thank you!
Best Answer

Hi @Beth Fantozzi 1 I think when you add in new rows the formula is seeing the blank ID Numbers as duplicates, try this formula to account for this:
=IF([ID Number]@row <> "", IF(COUNTIF([ID Number]:[ID Number], [ID Number]@row) > 1,1,0), "")
HTH!
Answers

Hi @Beth Fantozzi 1 I think when you add in new rows the formula is seeing the blank ID Numbers as duplicates, try this formula to account for this:
=IF([ID Number]@row <> "", IF(COUNTIF([ID Number]:[ID Number], [ID Number]@row) > 1,1,0), "")
HTH!

That's it! Thank you so much, Frank! What a huge help!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!