Drop down values in grid view not showing in report

Options

Hi

I've build a report from a grid sheet. All values shows, except in the columns where the column type is a dropdown. Is this correct?

Grid info:

Report info:

If I change the column type to text, it shows in the report.

But I would like to limit options in the report to a dropdown list.

Please help?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!