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.
