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)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives