I have a user input table with an enum drop down that has 4 values that are the same as 4 column headings in my main table called Full List Table
The column in the editable table that holds this enum is called [Entry To Change]
I have another drop down enumlist that shows a list based on which ever has been selected in the previous one.
In the Valid IF box it can use IF([Entry To Change]=“Outlet Rating”, Full List Table[Outlet Rating]…etc
How can I simplify the expresion to Full List Table[what ever has been selected in Entry To Change] as a dynamic enumlist.