Blueprint Summary Sheet Cell Linking Not Keeping Column Type Property
There is a cell in our intake/project pipeline sheet that is a multi-select drop down. It links to a metadata sheet when a project is provisioned and remains a multi-select drop down. But when it's linked to the summary sheet, it's just a text column with all the checked options typed out. I changed the property of the column on the summary sheet to be a drop down with the same options, but the choices remain typed out/don't update. How can i fix this?
Answers
-
What happens if you click the option to wrap text on that column?
-
It turns into a vertical list, which is helpful for other sheet edits, so thanks! But I figured out I just needed to turn on "Allow multiple values per cell" 🤦♀️ so that I could use CONTAINS("value", @cell) in a formula.
-
Glad you got it sorted. The reason I asked about the wrap text feature was to try to find out if it still at least had the line break delimiter.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 138 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives