Is it possible to populate a dropdown in one Smartsheet from the data in another Smartsheet and have that dropdown auto update once the data is updated in the other Smartsheet?
Example:
Smartsheet A has data pulled in from another source with a column labeled Full name.
Smartsheet B has a column labeled Full name and I want that to be a dropdown field, but is should be populated by the Full name column in Smartsheet A.
Is this possible?