Drop down values in grid view not showing in report

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
-
So, I think I found my answer. I've got multiple sheets that I'm picking up in this report. All headings are the same, but the column type is different - leading to different columns.
-
Hi @StephaneJvR
I hope you're well and safe!
Yes, you're correct, and there will also be a new column created if you change the type of one in the report already, so you would need to replace the old one.
I hope that helps!
Be safe and have a fantastic week!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!