Form

I am in need to create an order form but unsure of how to do it. Form has multi select dropdown list with all the inventory. Each person will select based on their request but then I need an box with the quantity of each item requested. Any ideas on how to do this?

Best Answer

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Answer ✓

    If you want to select multiple items in one cell (multi select) and also assign specific quantities to each item, it will be difficult to do so.

    I would instead break down your order workflow into a two columns for each item. First, what is being ordered and then the quantity needed.

    You can make this easy with a field in the form to select the number of items needed and then use form logic to show appropriate fields for this many items.

    With multi select, it will get complicated and difficult to pair the quantities to the appropriate item. Single select will also allow you to query a database or create one and stay up to date on orders, sales figures, or whatever it is that is of interest to you.

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

Answers

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Answer ✓

    If you want to select multiple items in one cell (multi select) and also assign specific quantities to each item, it will be difficult to do so.

    I would instead break down your order workflow into a two columns for each item. First, what is being ordered and then the quantity needed.

    You can make this easy with a field in the form to select the number of items needed and then use form logic to show appropriate fields for this many items.

    With multi select, it will get complicated and difficult to pair the quantities to the appropriate item. Single select will also allow you to query a database or create one and stay up to date on orders, sales figures, or whatever it is that is of interest to you.

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

  • Marc1a
    Marc1a ✭✭✭

    I figured! thanks for the info I will give that a try

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!