I've tried using a ref column but that only asks me what table I'd like to use, and I want values from a specific column of that table to be shown on my dropdown field.
Solved! Go to Solution.
Correct. And you ise a SELECT() in the valid-if expression.
In my case I just needed to name the table[column] in the formula. Used a sort function as well just for convenience.
Oh, right! I almost forgot about that shorthand - which is also what works for cascaded-dropdowns (dependent dropdowns).
User | Count |
---|---|
16 | |
10 | |
8 | |
5 | |
5 |