If Has on multi select with an Index/Match

Options

trying to get this to work.. but failing on correct syntax.


=IF(HAS("California", State:State), , IFERROR(INDEX({DS-Record #}, MATCH([WSGR Email]@row, {DS-Email}, 0)), "")), IF(HAS("CA", State:State), "")


ultimately, we have a multi-select option on the form, if they select multiple states we want it to look up their bar # index/match based by email AND the state.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!