Getting Combined Names to dropdown in a form.
Hello,
Our sheet has names captured in separate columns for first and last. I created an additional column that combines them with a formula to (First Last), however now I cannot use this in a drop down for a Form where the user can select their name from the list because the column has a formula in it. Is there a way around that?
Answers
-
If you convert the column that contains the first and last name together (even though it is based on a formula) to a Dropdown column type, you should see the list of names in the dropdown options on your form. Formulas generally don't prevent that from working.
If, for some reason, you do not see the names in the dropdown, one workaround is to create a new column, copy the names in the formula based column (but NOT the formula), then use Paste Special to paste the names into the new column. (Select Values when pasting.) You can then delete the formula-based column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!