If Has on multi select with an Index/Match


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!