formula work one one sheet but not another
ross chambers
✭✭✭✭✭
Hello I have a formula =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row > 1), 1, 0) that checks all the indexkeys in the column to see if there are any duplicates. This works perfectly on my tester sheet which is an exact copy of the sheet I want the formula on but for some reason doesn't work on the main sheet and returns 0 instead of 1 even when there is only 2 rows on the sheet with the same indexkey it doesn't work
Best Answer
-
nevermind i had the bracket in the wrong place =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row) > 1, 1, 0)
Answers
-
nevermind i had the bracket in the wrong place =IF(COUNTIF(IndexKey:IndexKey, IndexKey@row) > 1, 1, 0)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives