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???

Find more posts tagged with

Accepted answers

All comments

David Joyeuse

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.

Genevieve P.

Great catch, @David Joyeuse!

Let us know if re-typing the " marks directly into Smartsheet gets rid of the error, @Guangda Shi.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.