Using HAS to search multi select column @ each row in a single cell

I'm getting the formatting confused here,

I have a sheet where I want to in one cell search and identify whether a multi select cell contains a value and provide yes/no as a result. Team Name has a list of team names I want to search in to find a specific "Team". I want to look in line, having each subsequent row look at the next row's Team Name column and row. I thought the @cell and @ row would work but it says #UNPARSEABLE.

=IF(HAS([Team Name]@cell, [Team Name]@row "Team"), "yes", “no”)

Also is there a link for a good place to read up on how to use these cell references?

Find more posts tagged with

Accepted answers

All comments

NicoLHC

@Kate HC please try this instead , i hope its works.

=IF(HAS([Team Name]@row, "Team"), "yes", "no")

Kate H

@NicoLHC unfortunately that didn't work either.. any other ideas?

Kate H

@Paul Newcome any insight on why =IF(HAS([Team Name]@row, "Team"), "yes", "no")

is not parseable?

NicoLHC

@Kate H searching for Team A =IF(HAS([Team Name]@row, "Team A"), "yes", "no")

Bildschirmfoto 2024-09-19 um 15.36.27.png

https://app.smartsheet.com/b/publish?EQBCT=bf9fdfcb37e14066a81cfa8893183f90

Kate H

@NicoLHC it's still not working although the script is identical. Can you tell me the column type for your "results" column?

NicoLHC

@Kate H normal text field should i share the sheet with you ?

Kate H

@NicoLHC yes please share the sheet, I cannot figure out why this isn't working.

NicoLHC

@Kate H please send me your mail to nico.roepnack@lighthouseconsultings.com

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.