Allow multiple selections of the same item in a dropdown list

Sorry if the language is confusing, but here is my example:

We are encouraging daily physical activity for our staff. Entry will happen on a Form connected to a sheet where data will be stored and modified (SUMs where "5000", "7500" or "10000" exist in @row).

The dropdown list will have 3 benchmarks for steps taken in a day, 5000 Steps, 7500 Steps, and 10000 Steps. I'd like users to be able to click "5000 Steps" multiple times to allow entry for multiple days of data.

Is this possible?

Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would have to have multiple dropdown columns (one for each day) where users can select a single entry for each day.

    If needed, you can also set the form to automatically reload itself after submission so that users can more easily fill out a new form for each day.

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com