Dynamic Drop Down in Forms



I've tried googling and searching the forum but cannot find an answer for my use case.

As part of a 2 stage project approval process I want to create a form that has a dropdown option to select project ID numbers from a list of projects that have passed the first stage.

e.g. If I have 3 projects PROJ01, PROJ02, PROJ03 and only PROJ01 and PROJ02 have passed the first stage gate, I would like the dropdown to lookup a list that will:

  1. Exclude PROJ03 as it has not passed the first stage gate
  2. Exclude any project that has passed the second stage gate

Is this possible in Smartsheets? I was hoping I could create a report that generates the list and then point the dropdown list to that report...


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!