Hello everyone,
Hope you can help me with the following issue that I can't seem to make work on my own.
I have a list with checkboxes for users to make a selection of the metrics they want to assess/report in the 'metrics selections' tab. Based on the users' selection, all the cell values that showed up as 'TRUE' will be listed underneath eachother in the 'overview' tab. I want to connect a list dropdown based on the value that is found and listed in the first column in the column behind it. The list values are shown in the 'lists' tab. So this goes against the principle of the cascading dropdown menu's. I want to simply generate a dropdown list based on the metric value without that cell being the main dropdown menu.
Please see the attached file so it should make sense. If you have any questions, please let me know.
Many thanks in advance!
Cheers,
Remon
Bookmarks