Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions