Hi all,
I made a REF column where ALL supervisors of all the departments are listed (at first, I made them separately but it was complicated when I got to getting [email]) Is it possible, say for example, that if [department] is accounting, then show me only the supervisors in that department (pls see pic).
I know there isn't any tagging to know which department these supervisors are, or can I add to do so? Any other ways?
Please. Thank you!
Solved! Go to Solution.
Yes, you should add a Department column. Then you can manage the dropdown list via valid_if.
https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if
https://help.appsheet.com/en/articles/961554-dependent-dropdown
Yes, you should add a Department column. Then you can manage the dropdown list via valid_if.
https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if
https://help.appsheet.com/en/articles/961554-dependent-dropdown
Thank you. The instructions were simple but I honestly couldn't follow easily, somehow did it. But why does a warning appear here,
This is my valid_if expression
And this is the app formula I got for my referenced column 'supervisors'.
Do you know what caused this? Thank you!
Search here for "yellow triangle"
And now I couldn't get the [Email] of the Supervisor chosen.
This is my column properties for [Supervisor Email]
Can you tell me how? Thanks!
All done, thanks again!
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |