Convert into column formula w/o syntax error
Hello,
Could you help me please ? I try to convert following formula into column formula w/o syntax error , unfortunately without success. Do you know by heart how I can do it ?
COUNTIF([Unique Key]$1:[Unique Key]@row, [Unique Key]@row)
Ty,
Br,
Tibor
Answers
-
Hey @Tibor,
The issue is with the range.
Try this one: =COUNTIF([Unique key]:[Unique key], [Unique key]@row)
Let me know if I am missing something, what do you want the formula to do?
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Hey Itai,
Thank you very much , but if I use mentioned formula than I use functionality that I want to see, anyhow I found solution here https://community.smartsheet.com/discussion/31256/number-of-duplicates.
So thank you very much,
Br,
Tibor
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives