Trying to anchor formula to specific row

Alan Meshaw

SS Question.gif

Hi, I have entered this and it works:

=IF(FIND([SOP Required Group]1, [SOP Required Group]@row) > 0, "Y", "N")

but if I want to anchor to Row 1, I get an #unparseable error:

=IF(FIND(SOP Required Group1, [SOP Required Group]@row) > 0, "Y", "N")

What am I missing?

Find more posts tagged with

Formulas

Accepted answers

Alan Meshaw

Sorry, I actually answered this myself, but if anyone has a similar problem, here is the solution:

=IF(FIND($[SOP Required Group]$1, [SOP Required Group]@row) > 0, "Y", "N")

All comments

Alan Meshaw

Sorry, I actually answered this myself, but if anyone has a similar problem, here is the solution:

=IF(FIND($[SOP Required Group]$1, [SOP Required Group]@row) > 0, "Y", "N")

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.