INDEX calling data that is drop down format?



I am having difficulty using INDEX. I would like to use it to call a data point into a new sheet, but the data it is calling has been input in a dropdown format. The formula works for data that is text, but gives INVALID VALUE when the data being called is from dropdown. Is there anyway around this? If at all possible I'd like to avoid inserting a new data column to convert from dropdown to text.

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!