How to populate drop down fields with multiple entries?
How to populate drop down fields with multiple entries? Is the space between the multiple entries considered a space?
Answers
-
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)
-
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?
-
Thank you Paul.
-
@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.
-
@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!
-
@Walter Mootz Are you able to provide a link to it?
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
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
