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.

Index, Match formula problem

Hi, I have an index, match problem and I cannot seem to work it out. On Sheet- Asset Tracker, from the smartsheet templates, I have assets listed. I have added a concatenated the column Asset Short Descriptor with a formula concatenating information from asset make, asset bldg abbrv, and asset room num. I have copied all of those cells in the asset short descriptor column and pasted them into another sheet's column drop down box. That other sheet is Sheet- Maintenance Log. On that sheet, I want to choose from the drop down one of the items from asset short descriptor, and have it fill in some asset information on the sheet- maintenance log. Using a simple index, match doesn't seem to work in all cases. Any ideas?

image.png


image.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions