Dropdown field dynamic content

Joachim Mund
Joachim Mund ✭✭✭✭✭✭
edited 03/19/21 in Smartsheet Basics

Hi all,

how is it possible to fill the selection values of a dropdown field automatically from the unique list of content of another field with a logic like: status = not "finished"?

If we add a new project, we will have a form to give the user the selection one of these "active" projects. Today I have to edit this list manually :-(.

Thank you for all help and suggestions.