Find function not working. Can you help?
I'm trying to count a particular name in a column but keep getting the #Unparseable error.
=COUNTIFS({LR Date Created}, IFERROR(YEAR(@cell), 0) = 2020, {LR Date Created}, IFERROR(MONTH(@cell), 0) = Month@row, {Assigned To}, FIND(“Kamil”, @cell)>0)
Can you help???
Answers
-
Hi @Guangda Shi
Regarding parenthesis it is OK.
Though I remember @Genevieve P talking about it on another thread, but your quotes aren't exactly straight, they are a little curved for whatever reason.
They should be straight. Maybe you copied the formula from another text editor. Try removing them and retype them. Maybe that'll sort the problem.
-
Great catch, @David Joyeuse!
Let us know if re-typing the " marks directly into Smartsheet gets rid of the error, @Guangda Shi.
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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!