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

Kate H

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?

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")

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