I have set up custom metadata fields which are text fields with multiple options as drop-downs.
When I Lock the sheet, the drop-downs do not lock; those values can still be changed.
Is this correct?
Also - how do I get a “multi-line” text field to display in multiple lines? If I enter text longer than the width of the field, the text at the end is truncated rather than shifting to multiple lines.