Can I reference a range of cells to select from?

Options

I have a sheet for people to enter their time on. When they select a job number for their times from a drop down list, can the next cell give them specific "phases" for that specific job to select from?

This is a snapshot of the record of the time:

This is a snapshot of the sheet that describes the phase:


Best Answer

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭
    Answer ✓
    Options

    Hi @Laura Bell

    I believe @Robert Tebault is right here.

    Smartsheet does not allow yet to do some dynamic dropdown list (which would be a great addition to the product, so I would advise you to submit it).

    The usual workaround for this is to have a sheet with a form linked to it.

    In this form have a column to pick the phase you want. They have one column for each phase with the desired dropdown list.

    Then if another sheet use some JOIN/COLLECT, INDEX/MATCH form to pick whatever you need, ort use some row copy/move if that's a better solution, hiding the unwanted columns.

Answers

  • Robert Tebault
    Options

    I think the best way to handle this would be to use a form instead of a dropdown list and IF logic. With your sheet you can create a form that allows the user inputting data to answer simple questions. Question one could be to choose the Job Number from the dropdown list or radio buttons etc. Once they choose a job number, Form Logic can will allow you to specify a second choice and what options are contained in that choice based on the original selection. See the below link for additional information on conditional form logic.

    Use Conditional Logic to Streamline Form Submissions | Smartsheet Learning Center

  • Laura Bell
    Laura Bell ✭✭✭✭✭
    Options

    I don't think that will work here. For each job number, the phase numbers associated with it have different descriptions. So, in the snapshot below, if someone picks job N3033, they have the choices AA-AG, but the descriptions are different than they would be in job N3034.



  • David Joyeuse
    David Joyeuse ✭✭✭✭✭
    Answer ✓
    Options

    Hi @Laura Bell

    I believe @Robert Tebault is right here.

    Smartsheet does not allow yet to do some dynamic dropdown list (which would be a great addition to the product, so I would advise you to submit it).

    The usual workaround for this is to have a sheet with a form linked to it.

    In this form have a column to pick the phase you want. They have one column for each phase with the desired dropdown list.

    Then if another sheet use some JOIN/COLLECT, INDEX/MATCH form to pick whatever you need, ort use some row copy/move if that's a better solution, hiding the unwanted columns.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!