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.

how can i utilize when there are multiple selections from the dropdown

This is the formula i am using, but when there are more than one selected from the dropdown it will say #no match

=INDEX({chemical rate}, MATCH([Chemical Name]@row, {Chemical Data Sheet chemical name}, 0))

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions