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

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!