Formula not working
Hello,
I have a formula that is working in one sheet but is in another.
What I am trying to achieve is to add a 1 into a column when a number is featured in another column only once so I can pull that into a report.
I am trying to pull a status report of contracts but the contracts are listed multiple times.
=IF(COUNTIF([Contract No #]$1:[Contract No #]$11254, [Contract No #]@row) <> 1, 0, 1)
Answers
-
Hi @Faye Sumner
The range in your formula has a row start (row 1) and a row end (row 11254). If your first sheet doesn't have 11254 rows, then you'll receive an error, since it can't look that far down.
=IF(COUNTIF([Contract No #]$1:[Contract No #]$11254, < here
Can I ask why there are specific rows identified in your range? It looks like you just want to evaluate the whole column, is that correct? If so, you don't need any row reference at all!
Try this:
=IF(COUNTIF([Contract No #]:[Contract No #], [Contract No #]@row) <> 1, 0, 1)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!