Would be nice to have optionally filtering options for Related Row column type.
Related Row column should return a filtered value selection based on a specific column value of the same row or generally filters selection on specific view of destination workbook/worksheet.
Sheet1 contains a column 'S1Option" and two related row columns ‘RROption1’ and ‘RROption2’. Both RR are connected to Sheet2.
Sheet2 contains also a column ‘S2Option’ and some others. Sheet2 has also the views ‘Options1’ and ‘Options2’.
Selection values in columns ‘RROption1’ and ‘RROption2’ should be filtered by the respective values ‘Option1’ / ‘Option2’ of column ‘S2Options’
Selection values in columns ‘RROption1’ and ‘RROption2’ showing values of respective views.