How to populate drop down fields with multiple entries?

Margarita Takou · 08/05/20

How to populate drop down fields with multiple entries? Is the space between the multiple entries considered a space?

Paul Newcome · 08/05/20

You need to first have the column set as a multi-select dropdown type. Then you can manually select multiple entries, or if you are using a formula the space is actually a line break. You can see this when you enable text wrapping on the column.

Entry 1

Entry 2

To insert a line break into a formula, you would use

CHAR(10)

Walter Mootz · 09/25/20

https://community.smartsheet.com/discussion/comment/258753#Comment_258753

Paul, I have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to set it up that multiple items can be entered in at the same time and grouped together to keep work orders together, or will they have to go through and enter everything manually?

If they do have to enter a form entry for every part they want under the same work order, is there a way to program the sheet to group them together?

Margarita Takou · 09/25/20

Thank you Paul.

Paul Newcome · 09/25/20

@Margarita Takou Happy to help. 👍️

@Walter Mootz I am not sure I understand exactly what you are trying to accomplish with your first question. For your second question, sheets do not have automatic sorting built in, but reports do. You could pull a report from the sheet and set the sorting to be based on the work order.

Walter Mootz · 09/25/20

@Paul Newcome I posted a question on the community forum that may better explain my first part of the question. Hopefully you can help with that! If not, back to the drawing board!

Paul Newcome · 09/25/20

@Walter Mootz Are you able to provide a link to it?

Walter Mootz · 09/25/20

@Paul Newcome https://community.smartsheet.com/discussion/71601/can-a-form-have-multiple-entries-and-have-them-display-as-multiple-lines-on-the-smartsheet#latest

How to populate drop down fields with multiple entries?

Answers

Categories